I had a dream a while ago which i wouldn't say was lucid, in fact it was before i really knew what lucidity was, but in this dream i decided to shoot up heroin on a beach near me with a guy who i'm not much more than an acquaintance with.
Somehow though, the heroin felt amazing even in a dream. I guess that's the best i'll ever get because i doubt i'd ever try it in real life.