Yes, but not regularly, or even often.
In the last D&D game I ran, a PC was being courted for membership by a Yuan-Ti cult, who offered the PC a powerful hallucinogen. When the PC realized what was happening, he refused the offer and fled. If he'd taken it, I had the addiction rules (BoVD) sitting behind the DM screen.
I've put caches of recreational drugs into treasure hoardes, like if they raid a bandit lair they may find some narcotics. PC's in my games have always destroyed them immediately (but save the wine, and try and find buyers for any particulary valuable wines they may run across).
They aren't a regular part of the campaign, and certainly not something that PC's are encouraged to use, but they are present in the campaign world, typically as something used and dealt in by villains.
Now, if I'm running Star Wars, of course recreational drugs are a part of the setting, Spice is a key part of Star Wars. Ryll, Glitterstim and Avabush Spice are expensive, dangerous, and popular throughout the galaxy, people smuggle them (most people ignore that Han Solo was in modern terms, a drug smuggler), wars are fought over them, and if people overindulge in them, very bad things happen. (Then there are the stranger drugs, like how Arconans are intoxicated by simple sodium chloride).