Funny, I had a friend that used to be a big smoker. He would come to the gym stoned and then proceed to squat heavy. For the life of me I don't know how anyone could do that.
It's a great PWO lol. More serious, it really depends on the person. Some it helps them laser focus into the task at hand; others it makes them lazy or distracted.