I dont think condoms are gross or a turn off. That said, I do think there is something sexy about someone wanting to be bare with you (regardless what of youre doing). There is a level of intimacy to that (trust, openness, etc) that condoms dont offer.