The only "weak" major female character I can think of is Cortana. In general, the female characters I liked are actually the ones that make you forget what you're playing as due to the perspective, immersion, and non-sexualization like Metroid Prime or Faith from Mirrors Edge, nobody bought those games though.
Ever since I was like 14 and first got really into videogames, I always wanted to see a game like Bioshock or Deus Ex from a female perspective where you cannot customize your character's gender but you do have to make tons of moral decisions. You are aware of what genital pixels you might have but the way you play does not really change and in the case of Bioshock, I don't think you ever even leave the first-person perspective. And then in the sequel you would play as a robot and I think the third game was playing as like the Earth but those two don't really have many tropes to fight back against.
what do I sound like?
Sort of raspy and hoarse and quick in a sexy way but you're older and married so you're totally oblivious to it.