if you don't mean cigarettes, what I've found out is that just listening to whatever music you like when you're sober is the best. However epic progressive masterpieces such as "Visions" by Haken have a greater effect.
There's a scene in Goodfellas where Jimmy Conway is in a scene and smokes a cigarette to 'Cream-Sunshine Of Your Love' playing in the background. It's a cool scene and the music complements it.