I understand where you're coming from, but I feel like this ignores practicality and, coupled to that, social use. You can go on numbers related to health, or raw effectiveness, but those numbers don't measure practicality.
MD, mushrooms (and acid et al) are far too powerful (yes, you can take very small doses, but in general). To look at it coldly, they're just not at all practical, regardless of them having, I would say, far fewer direct negative health effects. Indirectly though, things that immediately change people's mental state to such a degree are I would say more dangerous than alcohol.
With alcohol, I can go and have a small amount with family or friends or colleagues, for a short period of time. I can do it home, with a meal. And the actual drinking of it is core. It's not like taking one the above drugs: I take the drug then I am mentally altered to a large degree, possibly for a long period of time. In the case of a selfish drug, like cocaine or an amphetamine, I can function, and the effects a shorter, but there's no social aspect. The actual sitting down with others to spend time imbibing is central.
Cannabis obviously has this in common, so I think that's a very fair comparison. And just to stay on topic, so does tobacco. It's not just the effect of the drug that's attractive, it's [what I think is fair to say is] the social ritual associated with it. It helps that taking those isn't quick (it's not just slipping a pill), that's a feature.