One of the questions here - who do you want to be? Do you want to be someone who will have one night stands with sufficiently hot men? There are people who are like that and are happy with it. There are people who would never be happy being like that. If you decide that you are like that... well, you might as well be who you are, and accepting it makes facing people afterwards that much easier. If you decide that you're not like that... I don't care who he is, or how hot he is. The experience of having a one night stand with him is not going to be worth the damage that you do to yourself in accepting it.
Also, if he's getting enough play of of just being hot that he can decide that he's only into one night stands and blab about it afterwards every single time, and still have women lining up, there's a good chance he's never bothered to learn how to please a woman. Why would he bother putting in that effort? ...and the "everyone ends up knowing" thing also suggests that he doesn't have a whole lot of respect for the women he sleeps with, which makes the chances of him working on your pleasure that much lower.
Don't think about it from the perspective of now looking forward. That's all clouded with hormones. Think about it from the perspective of one week after said one night stand looking back. If you're pretty sure that you'll regret having done it, then don't do it.
Also, I'd strongly agree with the voices calling for you to use protection if you do do anything with this guy. Nothing tips the scales towards "regret" quite like an incurable venereal disease.