Are there any specific stories or talks where Buddha discussed using mind altering substances other than alcohol?

>It goes without saying that alcohol makes you mindless. Theres debate about pot creating conditions for enhanced mindfulness in SOME individuals. My question is not "is it okay". I know what to expect. Are there any specific stories involving Buddha on the subject of someone ingesting an herb or something, specifically to be mindful... and how that is bad. I'm asking for the story or stories.