The relatability and characters issues depens on the story and the writing. A female protagonist doesn't have to necessarily fight against "female issues". Themes of a game can be universal Also, I don't agree about a character being relatable as a must to have any appeal. She can be just interesting, funny and/or having a cool design. And there are lots of games where story doesn't even matter, so in these cases why care about it? I don't think gender is everything.
About majority, I tell you this: why the popularity of Jill Valentine, Samus Aran, Lara Croft, female commander Shephard and more then? Why female protagonists like Heather Morris, April Ryan, Joanna Dark or Cate Archer were so beloved?Just by women and a minority of men? Why so many graphic adventures and survival horror games with female protagonists? I see facts saying a different thing. Also, how do you know women only want to play as female characters and they're not interested in playing as men? It's not that simple.
A different thing is the "modern" female protagonist trend, or the use of her. Homogeneization is always bad, the bald jacked male protagonist trend of seventh gen was veeery mocked for good reasons. Or the dull "relatable" male protagonist design like the bounty hunter of the cancelled Prey 2 or nuDante of the dmc reboot, they were memes. The trend of nowadays with (bad) female protagonist is even worse, because now it's using "moral reasons" as an excuse. And the same boring and tiring kind of woman, and not for women, because, among other things, reducing femenity is antiwomen. Being ok with violence and gore but no with sex appeal is nonsense and not even a "modern sensibility" (that bullshit is very old, specially on USA). Making everything about identity politics is tiring. Preaching the audience like they're stupid is insulting. Doing that and using women as a (bad) replacement of men and not leaving place to the later is even more insulting. And I'm not even talking about doing it in established franchises.
Yes, in the past there were more male characters than women, but there wasn't any wish or try to eradicate female protagonists, nobody wanted changing genders or race on Metroid, Fatal Frame, Tomb Raider and others. And I'm not even talking about most of crpgs, where you can choose gender since...always! Nothing like nowadays, where playing a man without being emasculated or sided and femenity are "taboo" now, specially on western videogames. Not the "same as before but on reverse", and not more "empaty", "diversity" and "relatability" than before.
All of this are real problems to me, not just playing as a female. And if you think in this way...well, I think the modern state of the industry is affecting you (and I'm not blaming you). And if it's not, just "a man wants to play always as a male characters because more relatable stories "...well, I don't agree with you and, sorry, I think you'll miss a lot of great videogames.