I am clinically diagnosed ADD, I also have suffered from stage fright early in my gigging days, and I am a singing drummer. I often have a drink or two (at the MOST) before sound check, just to knock the edges off. That's usually at least an hour before downbeat as I am always the first to arrive for load-in, and often that was straight from work.
I was prescribed Adderal. It did help me to a point. Struggles in remembering lyrics, which were the first thing I'd lose as my focus would shift during songs. It didn't matter that I'd known the song for 30 years, I had way to much going on mentally and physically and the Adderal did help with that..... But, I had far to many comments from friends of the band that I looked "all business and no fun" or "a robot" up on stage. I stopped taking it before the shows, and got an iPad to act as a cheat sheet for lyrics.
Tried smoking a joint before practice ONCE, and well, that was a bad idea any way you want to look at it.
Do I get buzzed? No. Do I get wasted? Absolutely not! Does it help me relax? YES!