For once, I massively agree with Yahtzee's point here. While you often see polls, top tens and other such lists for 'memorable' female characters in games, and the 'good' ones are known to many (Aeris from FF7, Alyx Vance from HL2, Jade from Beyond Good & Evil, Faith from Mirror's Edge etc etc) it is counter-weighed if not full-on swamped by the vast array of 'bad' girl characters.
I can see what Yahtzee means by the exploitation angle, but even so, the girls in something like Frank Miller's Sin City, or Tarantino's Death Proof are not psychotic bitches. Without renting out the back-catalogue of Russ Meyer and going into infinite detail about Faster Pussycat Kill Kill and Ilsa the Wicked Warden, it is fairly easy to see the roots of the character in Wet forming from movies like Romanzo Criminale, Aliens and Smokin Aces, only to be dragged down a bit later down the production stage by the likes of Barb Wire...
For my sins, I am currently playing Risen. Feelings about that RPG aside, I have so far encountered the gamut of female stereotypes. Ok, crap example because of the limited number of character models meaning they all look largly the same, so the prostitute with no conscience looks almost the same as the one wearing no clothes but spouting prophecy, and also look similar to the two female characters I care about on a level other than 'NPC to talk to', so its not a question of who has the biggest boobs. How they react and talk to me, the player is the main piece of intrigue here, and Piranha Bites have almost got it right in a few places. Its easy to pigeonhole them, making them a good, almost 'museum piece' source to point to and say 'this is what games designers think this kind of person is like'.
Returning to topic, and yes, I am also a fan of Soul Calibur, have owned Dead or Alive at some point in my life and actully paid money for Onechanbara (staff discount is my only defence) so I am the hated male chauvanist exploiter who propagates the desire for big boobs and outrageously impractical clothing in the games I play. I could argue that this is catch 22, if they weren't there, they wouldn't sell, and the games are actually fun to play in the first place, but for every Ninja Gaiden 2 there is a Dreamfall or Mass Effect in my collection. Some people found the female characters in Jericho jarring, I found it rather eye-opening. Tough-gal exteriors aside, there was that bit where the chaotician broke down into gibbers and the blood-witch was asked to comfort her. For a period of about a minute all pretence of bitchiness and hard-ass were gone, replaced with actual intelligent introspective. "She gets like this. She still suffers from night terrors, and sometimes wets the bed." Its para-phrased from memory, so probably not exactly as said, but the delivery is actually caring, concerned. I'm guesing Clive Barker had a bit more to say on that bit than some of the rest of it. He took the lesbian hard-ass babe stereotype and softened it at the edges just enough to care when she died later in the game.
I like my women real. I'm sad to say that in today's vacuous society the made-up personality of a well-designed female games character is a lot more appealing than the pig-shit thick, Heat, More and other gossip-mag reading 'woman' that is sadly the common norm in real life right now. I'm not saying I'm in love with Alyx Vance (I think my little brother had a crush on Chun Li when he was 10 though) or Lara Croft, but I have often found myself wishing someone as well-rounded and intelligent actually existed in real life and was as easy to find. Games are, after all, an escape.
Yahtzee's comments struck a chord here because I have created a female character which I use in a lot of the table-top RPG sessions I run, and am trying to write a book involving her. As a heroine, she needs to be bad-ass on occasion, without falling into the trap of becoming a *****, or else people won't be able to warm to her and feel for her when tragedy occurs. The sentiments and comments he made here act as a sort of warning, and guideline, putting into perspective the perception of female characters as a whole.
But then, there is that female scientist from Command & Conquer: Renegade... she was cool for all the wrong reasons.