I think this has happened to nearly every straight man alive at least once. It goes back to the myth* that all men are unthinking sex beasts and would have intercourse with a radish if it wore some lipstick and looked at us fetchingly.
If I were dating, though, I’d reject anyone with a tattoo or a terrible personality, which is 95%+ of women out there (and even more men, to be fair). So that’s a lot of “being gay” I’d experience I guess.
*Women believe this because ~5% of men are in fact unthinking sex beasts, and women get hit on 99% of the time by these serial pesterers and think that is all men (for some reason).