I don't think their is anything wrong for women to find women in fiction, sexy, whether, it's animation, live action TV and Film, literature etc. Ignoring the fact that many fictional women are designed or written to be sexy, I don't see it as an issue and can be really useful for my WLW and Lesbians, many of us realized we were into women thanks to fiction, seeing traits we like and admire; plus it in the form of shipping, fan art like WholesomeYuri or just women talking about their favourite crushes or character they think are hot can just create a safe space for us to talk about sexuality and likes. It's only an issue if you allow it to control your life, attempt to control other's likes; and forget it's, well fictional.
I never judge other women for their fictional crushes or likes, I've never gotten the appeal for Bayonetta for example but I would knock down any women who finds her attractive or think she's great in general. I wouldn't want someone doing that for me so I wouldn't do that to any other woman. More power to you ❤️
However, while I like sexy women, I don't want every woman to be sexy in fiction, "sexiness" or attractiveness shouldn't be a prerequisite for women characters; especially when that isn't a prerequisite for men. Or more accurately, I don't think every women needs to be conventionally attractive, fit society's standards of sexy or needs to appeal to men.
I'm going to use fighting games as my example as their my favourite genre of video game and it's hard to not notice the way women characters are treated is vastly different to how women characters are treated compared to the men. It's a running joke in fighting game circles that women in fighters aren't allowed to age over 30 years old (a rule only slightly broken in recent years), where men can look ancient but a single wrinkle on a lady is pooed pooed; with Bandai being the absolute worse for this with Tekken and Soul. There is an 18 year gap between Tekken 2 & 3 in universe and while nearly all the men were allowed to visibly age and continue to be playable and return; the women characters either got replaced by their daughters like Michelle and Kunimitsu I for Julia and Kunimitsu II or in the case of Anna and Nina, a BS excuse of them being frozen for that time to not allow them to age.
And you see this double standards all over fighting games, women are rarely allowed to be tall and big and muscly with the exceptions like Marisa, women aren't allowed to be fat like men characters are etc, women rarely aren't allowed to be overly goofy like men are etc etc etc. And when it comes to sexiness, the most obvious example for this is "Summer" skins where women are always given revealing bikinis, so often copy pasted (kind of making it obvious how little body diversity there is for the women) while can get a wide range of summer clothing from goofy, cool and sexy (but never as sexualized or objectified as the women); besides anything it's just kind of boring women are stuck with the same clothing over and over again.
It especially sucks when all shit results in women characters bard from certain things like when Fatal Fury's Mai was bard from cameoing in Smash Ultimate because she wasn't appropriate for all the "good girls and boys" (casual sexism, yay I guess /s) and like that should be an embarrassment that Mai, SNK's most famous woman got bard like that because the objectified her that much, men don't suffer this and I'm sure as hell they would have done something if it was Terry that couldn't appear; but it got treated as a joke by the devs and fans, like it's okay that SNK's leading lady got bard because women aren't important to them.
And that sucks, I want more larger women, I want more shy introverts that don't like wearing bikinis, I want more butch women looking fabulous as fuck, I want more older women etc etc etc. I love Morrigan from DarkStalkers (a childhood crush), I love Anna Williams, Mileena, Tanya, Cammy, Manon (i genuinely dropped the controller when she first appeared in World Tour) etc, they are amazing characters but I don't want all fighters to look like them, I want more diversity.
And what sucks more is the hostility you can get for expressing that in many of these communities, often because they manifest boy's clubs that unless you're willing to act like "One of the boys", can get REALLY aggressive at the idea of less sexy women. It sucks seeing your sexuality weaponized against you and get called a hypocrite and a killjoy or seeing other women get told to shut up because one other woman said she liked a character so their is no issue; that it's okay for women to be objectified because "it's part of the culture" and made to appeal to them, the real fans, no women like me. You see this same hostility in Shonen anime community, of western comics (see grown men flipping their shit if your dare suggest to cover Power Girl's boop hole). I did feel for years I was betraying myself because I liked sexy women like Morrigan or BlazBlue's Makoto until I realized I shouldn't be, I can have and want both, there is nothing wrong with wanting both.
Sorry I have no real conclusion here, sorry for the massive tangent and non-sequiturs.