Yeah, I wouldnt find a man hotter just because he's smoking, in fact it would decrease his likeability in comparison to a non smoking man. However, a sexy man is just sexy at whatever he does, eg. Jude Law.
personally, yes. If I like someone, then find out they smoke I am always just that little bit more attracted to them. I have recently given up smoking so I should probably try to kick this particular quirk too :/
But yeah, it probably depends woman to woman, how they feel about smoking to start with.
Purely on the basis of first impressions, I find it attractive (but I have always liked the smell of smoke.) I'm pretty sure it would get less sexy as time went on and the health problems started to kick in, though.