Hey you forgot the oblivious Best Friend archetype. Pretty much exclusive to JRPG, but it happens enough to merit mention methinks. They're all up in that main characters pants, but won't admit it until one of the two of them is dead or about to die, or something to that stupid degree. Usually a good fighter, but not as good as the male lead, if you fully upgrade their skills/equipment, they'll be in your final squad but, again, never better than the male lead.
Notables: Aika from Skies of Arcadia, Tifa (of course), Marle from Chrono Trigger, REbecca Chambers and (arguably) Alex from Half Life, much love for Alex though, she's a bad ass.
Great females characters though are indistinguishable from great male ones, their strong physical and mental attributes make them rise above ANY gender stereotypes. They have a strong sense of what their doing within the context of the game and are both willing to stand up for themselves in the face of adversity and offer a helping hand when needed.
Couple that come to mind; Ursula from Gladius, Jade in Beyond Good and Evil, Aerith in VII, Alex in Eternal Darkness: Sanitys Requiem, Samus, Olga in Metal Gear Solid Series, Velvet from Odin Sphere (and Gwendolyn to a lesser degree, Mercedes though? If she didn't have a Rambo style crossbow, she'd be pixie flavored toast in 5 minutes) probably some others I'm not thinking of, but woot-ever, ya'll get the point.