I think with the alchoholic community it would be a failed society due to hightened emotional feelings for a lot of people and there would be way to many disputes. Nothing would get done.
With marijuana it would be a lot like now, but slower, Some people work better on marijuana but a lot just get lazy. But shit idk .
With psychedelic substances (Dmt, shrooms, LSD, mescaline, etc) It wouldn't be practical at all. Since tolerance with those substances builds up quickly every day wouldn't be practical at all. But if people got equal highs every day for some odd reason, or if it was being used every week, HPPD would be effecting everyone within a couple months time leading to distorted perception of things and it would be shit. BUT If it was once a month or something and everyone in the community met together to do it, I think you could have an awesome community. Actually, I take back the every week thing. It could be done. If it did work, I think you would meet some great, insightful people. And some crazy's lol.
Opiates. (Heroin, Morphine, Opium). These I don't know much about, but despite the physical harm I did see a documentary called "Your body on drugs" which they tested people with different drug use and surprisingly the girl who was on heroin did every challenge very methodically and performed far batter than others. I think that it would actually be PLAUSABLE for a society based on opiate use to exist, although it would take a number on peoples body's so you would need a more technology based community then labor intensive.
Now for stimulants. (Cocaine, Meth). I don't think this would work at all. Maybe if the working force was stimmed, but not everyone. Long term projects don't seem like they would work out. Not very practical.
Ecstasy, I don't know ware this should go BUT I think this might work. I'm not sure how It would work with the labor, but It might work well since ecstasy has a tendency to putting you into a sort of trance with physical movement. Also, the community would be very understanding I'm sure, do to ecstasy's usefulness in therapy and recovering supressed emotions. It would be interesting.
As for deliriants (Dph, Ketamine?). NO. But it would be hilarious. Maybe.
That was a good time killer lol.