I think you are minimizing the physical aspects of sex and the necessity of attraction for sex. Yes, good sex has connection and the mind plays a big role, but attraction is absolutely necessary for sex to be enjoyable, and I’m certainly not attracted to myself AT ALL. (I do not enjoy sexual activity with the same gender even in the slightest, which seems similarly important.)

Also, you’re assuming people are honest with themselves (BIG ASSUMPTION) and that they don’t just hate themselves. I guess you could fantasize about hate-fucking yourself, but that seems like a topic for therapy.

I don’t want to yuck your fantasy yum, but I think it’s a lot more niche than you might realize.