In general order of impact in my life:
Call me old fashioned but I liked FF7 Tifa, and still do. She's beautiful, through and through, inside and out, and she can demolish pretty much anything under the sun all on her own. I never was a huge fan of her AC revamp, though.
Star from Yie Ar Kung Fu was before even Tifa as it came out in 1985. Simple, yet elegant in her own way but she's my first lady of fighting games even though I couldn't play as her, and she kicked my ass more than once. I was shocked seeing her in my youth. I hadn't seen many women fighting before then. She said nothing, and had no known character but her throwing stars bullseyed my young, prepubescent heart.

Hyadain's Yie Ar Kung Fu song was pretty nice.
It's prolly cheating to say Motoko Kusanagi as she's an anime character/manga character first, videogame character second, but I enjoyed her roles in the psx fuchikoma piloting game, and Stand Alone complex for ps2.
I pine for the day when I can be in her shoes as a mostly converted cyborg that looks that spectacular.
Chun Li stands out as a strong contender. I generally enjoy seeing her in action.
The women of Koei are nice (largely Warriors Orochi, Dynasty Warriors, and Samurai Warriors). They're usually married, though.
Tali from Mass Effect made me fall in love with Quarians as a people, and I am always bummed in knoweing my femshep never had her as a romance option.
I like beautiful, compitent, intelligent, powerful women. They can have flaws, certainly.
Not many guys really stand out that I can remember crushing hugely on.
Zhou Yu, Ling Tong, and Jiang Wei from Dynasty Warriors are pretty awesome, though.
The recent Batman games had a nice batman, thanks to Kevin Conroy voicing them.
Wrex and Garrus from ME are cool in my book. garrus knew the way to my heart via his gift of armor piercing ammo.

I warmed up to Zaeed quickly in ME2, and 3.