I remember listening to a programme on the radio here in the UK quite a while ago - the subject under discussion was 'women and power' and it was a prety well-informed and intellectual examination of what happens - and what has happened historically - when women have access to great power, especially political and/or military power. The consensus was that it generally doesn't end well, usually resulting in wars, political repression and other undesirable outcomes. Yes, women in position of power can become autocratic lunatics, too.
Of course, this doesn't absolve men from millenia of war and waste, but even the female historians on the panel seemed to feel that all the weaknesses and failings traditionally exhibited by males in positions of power become somehow magnified and still more destructive in the hands of a woman...
Ripley is a great example of just such an outcome. She might be 'kick ass' etc, but you wouldn't want to cross her, or expect to engage her in meaningful negotiations: she knows she's right about absolutely everything and like all good fascists, she'll brook no other opinion that does not fit with her own view of the world. Her solution to the problem of alien infestation? Nuke everything. It's left to the man beside her to beg for a moment's hesitation, a rethink...some simple compassion.
It's also worth mentioning that as the films progress Ripley moves closer and closer towards becoming one of the xenomorphs herself: a creature wholly without cloudy notions of conscience, morality or guilt. An unfeeling, calmly efficient killing machine that even the relentless aliens themselves learn to fear... Just what was Ripley - or the scriptwriters - telling us about this woman's journey towards power?
Maybe, on the whole, we like Space Marines because they are inherently fallible - in a clumsy, half-assed kinda way. It's reassuring to know you're only human, you're prone to make mistakes, you're not always right about everything and sometimes you get scared. I think on the whole I prefer playing as a Marine, rather than as a 'fighting mom', if it's all the same to you. I sincerely hope the devs creating the next Aliens game feel pretty much the same.
PS: Oh yes, as another example of a strong woman in a position of power, how about Captain Janeaway in ST: Voyager? During her tenure she presided over wholesale genocide, countless violations of the Prime Directive and appalling lapses of professional military conduct...