Smoking a cigarette can be SO sexy ! I do remember that sensation, the smoke between the lips, the cigarette negligently held between fingers.
But with a pipe... God, you gotta be very imaginative to find it sexy ! (okok I took extremes as examples!).. :P
I really like smoking the pipe, specially that German tobacco that gets a mirabelle taste.
But then it's a selfish pleasure, I like smoking my pipe in a very quiet moment. Alone.
I prefer holding a cig than a pipe though (I should stop talking of that, my hands are trembling from excitement, or so! :P)
Smoking a cigar, as a woman, feels very sexy too. They can be so ....ermm.... big!