Let me give you a bit of a different perspective. I'm a sex worker, so almost all the sex I have is transactional, and its basically part of the job description that I don't have to "fancy" someone to have sex with them.
For me, it's perfectly possible to have sex with someone I don't find visually attractive, but have great sex anyway. It totally depends on their skills in bed and their attitude. If we have good conversation AND they have good oral skills then I'm certain to have a good time.
To me the most "fanciable" thing is their attitude. If they arrive freshly showered (or take one on arrival), speak to me friendly and respectfully, genuinely want me to get off and are respectful of my boundaries, then that's a guaranteed knicker dropper.
My two favourite clients: one guy who is morbidly obese and has mobility issues following an accident. He has amazing oral skills and is interesting to talk to. One guy who is kind of hard to look at as he has severe facial and torso scarring due to an industrial accident some years ago. He is very witty and intelligent and our sexual responses are wired the same way.
I've seen plenty of guys who were conventionally attractive but never have I really enjoyed myself with most of them because some of them think their looks are an automatic knicker-dropper and they don't need to do anything else. Ditto a lot of guys who have a larger than average penis. Like they drop their kecks and they think you're going to go "OMG baby I'm so wet" 🙄