The only stumbling block came when the interviewer asked "have you smoked marijuana?". I truthfully answered no. The interviewer suddenly changed from bored old lady to the hardened, ex-cop that I suspect she was, glared into my soul and asked again. "No", I answered once again. "Well, that does not check out with your background. We will have to ask around on that one." She did ask around, my friends corroborated my story and I got the clearance.
My background involved undergrad education at a #1 party school, in a college town where open marijuana usage was common well before being legalized. And I had casual experimentation with other drugs (the aforementioned shrooms) and plenty of alcohol usage. I was probably the only one in my college acquaintance circle that didn't smoke on a semi-regular basis. I sometimes think I could have lied and said "yes I smoked weed", and still gotten the clearance. It would have actually been less of a red flag for the investigator(s).
It's also very easy to detect because pot stays in your system longer than about any other drug and the penalty for pot use by non-firearm owners is so weak and unenforced that people often forget it is a very severe crime for the ~40% of US that owns arms. People mistakenly get nonchalant about it.