And your expectations are correct.
I've used cannabis for recreational purposes, and while being high does give you interesting ideas, actually converting them to a piece of logic (i.e. a program) seems to be impossible. Nothing I've ever programmed while under the influence of marihuana has outlived a review while being sober.
And that's not the worst part.
While I was smart enough to only do this in my own time, I used to have a colleague with a somewhat... broader... view on the subject. Maintaining his code always felt like reading through a piece of Stream-of-consciousness literature.
It has enforced my own beliefs that recreational drug use does NOT deliver better code; quite the opposite.