Ok I'm not updated with the newest chapters of the manga so idk if this has been proved wrong, but I am 999% sure that Hancock's fruit "Love love" enhances โ or rather, uses to its advantage โ the person appearance for it to have an effect on anybody who considers its user pretty/cute/sexy/handsome. I mean, you don't need to have sexual desire to feel fascinated by someone's looks, so even people who haven't developed libido or are aromatic/asexual/straight(women)/gay(men) could fall under its power as long as they believe S-Snake or Hancock are pretty.
Maybe you don't necessarily need to be by any means conventionally attractive, because (going along with my theory) as long as you have eaten the fruit, the "% chances of being perceived as desirable/adorable" go up. So ugly user would go from 0% to somewhat relatively higher chances of being perceived positively by their looks, even though they look the same before eaten that fruit. And so, if someone who is already the cutest/prettiest person by social standards eats it its effect is of 80-90% of probabilities that they can turn anyone into stone.
Obviously, there are exceptions like Luffy, because maybe the fruit only amplifies the "cuteness aggression/ sexy appeal" level of someone on those who would *already* see the user as such without the fruit, but its effect may be useless when it comes to people who โ with or without the fruit โ don't get aroused/flustered by its user
With this in mind, gay men / straight women / kids / aromantic and asexual spectrum individuals who consider Hancock or S-Snake cute or pretty, regardless of how they feel about them as characters/people like them, could be petrified. Practically anyone regardless of their gender, age and sexuality. But the opposite thing goes the same: even those who are bi / straight men / gay women / aroace with capacity of developing sexual/romantic desire could be immune to them as long as they don't gaf about that person looks. So you wouldn't necessarily need to be a straight girl or a gay boy to not get petrified; the fruit effect doesn't alter or has immunity because of social constructs like gender and sexuality, therefore whether it works on a character or not isn't proof of the character orientations, simply of their positive opinion about Hancock/S-Snake appearance!
What I wonder is: If a person doesn't care about Hancock's looks โ that is, they don't have an opinion on her of their own โ but is capable of recognising she fits what others consider as conventionally attractive, would the fruit effect work on them or not? I mean, we know there's a difference between "I think this girl is attractive" and "idgaf about looks or bodies (or at least that person's body in specific) but I know from experience that they're considered attractive" but does that fruit effect recognises it too? Because if it doesn't then it would mean for it to not work you'd have to be
A. in the extreme point of aroace spectrum. As in, you have not only never had romantic or sexual desire in the slightest since you're born to this very moment in your life, but even if someone explains you what is considered by beauty standards "pretty/cute/sexy" you wouldn't be capable of recognising the similarities or patterns between Hancock and the examples your friend has given you to explain what attractive is considered
B. You are capable to any degree of developing lust/romantic feelings for someone, but your perception of physical beauty is so desynthesized from standards that your mind and body doesn't react accordingly to what for the majority could be pretty/hideous. For instance, Luffy could have "beauty standards", but because his compass deviate from the normal thing, and because Luffy is not the type to explain his vision of the world in a detailed way, from the outside you may think he's either uninterested in anyone or "blind" to physical appearances. So only by being Luffy himself it'd be possible to tell what he truly views as appealing, and it will forever remain a mystery whether he find anything on anyone cut until/if he shows it
C. You are capable of developing sexual, physical or romantic feelings at any point of your life. But just like in case A, not even with someone pointing out what is considered attractive to most people it clicks within you to recognise "that person is conventionally attractive". Like, "yes, I can hear you saying that woman is beautiful, I just don't get it??"
If I recall correctly in some points of the story Luffy calls some things "cute", so regardless of his sexuality he can see beauty in the physical aspect.
So the fruit's effect really only works if you deem her attractive by your own standards of beauty and not because of your knowledge of others perceptions? That would mean recognising someone would be appealing for others or fit someone's criteria โ perceiving that person looks as attractive and worth looking at