I used to like it, but now it honestly makes me sleepy and unmotivated. So I tend to avoid it. A drink or two while I'm performing is okay, but serious alcohol use is a big no-no at gigs, for lots of reasons. One, club owners generally don't like to deal with drunks, it makes you look very unprofessional. Two, it does absolutely NO favors for your playing.Three, really sloshed band members are a danger to everyone's equipment. ( I will never forget the night our totally trashed 6'7" bass player fell into and demolished my rig on stage!!! ) Four, alcohol can "amp up" any disagreements, hard feelings, etc, between the performers. Nothing says We'll never work in this town again like open fighting on stage or in the club.
But I do think that the effects of weed are different for everyone. It didn't always make me feel that way.