Absolutely. Old-world Mahasiddhas were notorious for drinking alcohol, but never became intoxicated. Take Tilopa, Naropa, Marpa, and Milarepa, for instance. I'm not a Kagyupa, so I can't give you as much info about them as they could. But I can tell you that the 19th century Terton Do Khyentse Yeshe Dorje drank quite heavily, but was never drunk. There are many stories to attest to that.
I guess this is finally the time to tell the story of Dudjom Lingpa and tobacco. Dudjom Lingpa himself smoked cigarettes, quite frequently. As happens with the disciples of great Lamas, everyone started smoking, to imitate the Guru, thinking it was a good thing to do. . . and most probably enjoying it. Of course, it didn't take Dudjom Lingpa long to catch wind of what was happening, so he called a big gathering in the large assembly tent of all his disciples. He stood in front of them, and said "Hey, so I hear many of you have taken up smoking! " and they nodded their heads.. and he went on, "OK, so then let's all share a smoke together!"
He pulled out his cigarette and lit up, as did the rest of the group. Everyone took their drags, exhaled, etc. . . but they started to notice something odd about Dudjom Lingpa. He kept taking drags of his cigarette, but he was not exhaling
. This went on for some time, and the longer it did the more everyone became uneasy, as this was very eccentric behavior from a quite wrathful Guru. Once he knew he had everyone's undivided attention, still not having exhaled once, he extended his arms and legs, at which time he "exhaled" all of the smoke he had inhaled from each of his fingers and his toes!
He then asked if anyone else there could do this. Of course, he got muted replies "no, we can't Rinpoche".
So he explained: "I only smoke tobacco because this substance will create terrible suffering in the future to vast numbers of sentient beings, and I am taking on and purifying some of this negative potential. . . "
". . . Is that what you all are doing when you smoke?" --
"No Rinpoche, of course we don't have this capacity" they replied.
And he made it very clear from then on that none of his disciples should engage in this activity unless they had his capacity. . .
Suffice it to say, in the Dudjom lineage smoking cigarettes is considered a very negative activity.