There is some debate nowadays about the use of alcohol as a substitute for bad water(1).
I think the reason you find alcohol so interesting because of the Iron Law of Prohibition(2): 'The iron law of prohibition is a term coined by Richard Cowan in 1986 which posits that as law enforcement becomes more intense, the potency of prohibited substances increases. Cowan put it this way: "the harder the enforcement, the harder the drugs."'
I'm reading the Kalevala (The National Epic of the Finns), and there is a lot of talk about brewing "table beer". I didn't know the term, so I had to look it up: beer of 1-2% alcohol, suitable for drinking during meals.
I think the reason you find such a range of "responses" to alcohol is not the drug itself, but because of the fact that it's legal, and therefore not subject to the Iron Law of Prohibition, you can buy it in a variety of strengths-- from beer to wine to liquor. It's not the drug per se, but its manufacture.
But, if you're going to go through the trouble of breaking the law to sell or buy and use illegal drugs, you might as well make it "worthwhile". That's why you could not find beer or wine during Prohibition, but you could get hold of high-content whiskey and vodka, even white lighting, moonshine, etc.
Likewise, contraband drugs have from from morphine to heroin to even more powerful manufactured opioids. If you're going to risk buying a sheet of LSD, get a dose of 70 micrograms, instead of 20.
Meanwhile, in silicon valley and other places, there is a new trend of microdosing(3): taking sub-threshold doses of "hallucinogens" to the point that _you're not even hallucinating-- but you do experience the "side effects" of increased alertness, awareness, creativity, memory, and problem solving. So there are doses of LSD, mushrooms, etc you can take that are not very powerful at all. It all depends on how they are manufactured and sold, just like alcohol.
Even now in South American countries, the most popular form of "cocaine" is coca leaves-- which, by contrast, are actually very healthy, and the first response to potentially deadly altitude sickness when pills aren't available.
I would suspect that if drugs were legalized, you would find a lot more forms with a lot less power.
1. http://leslefts.blogspot.com/2013/11/the-great-medieval-wate...
2. https://en.wikipedia.org/wiki/Iron_law_of_prohibition
3. http://www.forbes.com/sites/robertglatter/2015/11/27/lsd-mic...