When I think back of the most memorable nights of really wild, great sex...I always was under the influence of some sort of substance. So...yeah I prefer it.
Drunk sex is always fun in that you do stuff you might not otherwise do. Especially if it's with a newer chick. As far as pure pleasure, I like to be stoned.