Sure, it may make no sense that alcohol and tobacco are legal but weed and mushrooms aren't. They're all natural substances, they are all mood altering, they are all capable of being enjoyed in moderation and also can cause harm if used in excess.
But though alcohol and tobacco are legal, for whatever good or not good reasons, that isn't a logical argument for making more intoxicants legal.
"Alcohol is legal, therefore anything less harmful than that should also be legal" isn't a logical argument?
To be clear I don’t buy this argument since I disagree with the premise, but if you agree with the premise then it does make sense.
The point, of course, is that comparable harm from alcohol is not dispositive in the discussion of a ban on hallucinogens.
Obviously, the notion that LSD is no more harmful than whiskey is also not broadly accepted in our public policy, or really the public policy of most western countries. So there's (at least) two hurdles for your argument to clear. But I'm stipulating the latter argument, because it's the logic you're employing that bugs me, not the equivalence you're trying to draw.
These are positive arguments, not normative ones.
When you are saying you will take someone's freedom, their employment prospects, their whole life away because of possession of a substance, you need to be able to justify what you're doing, and to show how the action you are taking to suppress the substance is not causing much more harm.
Look at the war on drugs - that argument has been resoundingly lost. States and countries are starting to realise it.