I think a lot of it comes down to effeminate men not being attractive to almost everyone. Effeminate men are almost always synonymous with gay men. Gay men want to sleep with straight men and "Straight" men also want to sleep with other straight men.
I've seen "straight" guys so fucked up at the idea of being gay or bi that they dress up as women to make it feel more right to them. Kinda funny but also a lil sad.
Everyone wants the Straight cock.