Sounds like a strawman argument to me. I don't see anyone advocating that people do heroin as much as they ingest alcohol.
LSD and other 5-HT2A agonists are self-limiting in that they induce a massive tolerance after a single dose, making subsequent doses either not work or give diminished effects that do not increase with increased doses. They also are not physically addictive like alcohol is, nor does LSD cause organ damage like alcohol does.
Beyond overdoses, opioids, other than ones like MPTP, don't cause physical harm to the body like alcohol does. The dangers of heroin come mostly from its criminalization, the criminalization of addiction and the lack of access to healthcare to treat addiction. For example, there are millions of people who take Suboxone, a long acting and powerful opioid that stays in the blood for 30+ days, without it causing organ damage or seizure disorders. Street heroin is dangerous because it is unregulated and often cut with fentanyl and stuff that should not be going into veins.
The issues surrounding heroin would be solved with a regulated supply of clean heroin, medical support to administer it correctly, addiction treatment and making all of those things accessible and affordable to the people who need it most. There are several examples of governments that provide all of these things, and they indeed cut down on heroin's mortality and the devastating effects of addiction.
Similar to the person I know with heart disease from alcohol, I know a former heroin addict who also has heart disease from their use. Their heart problem was not caused by heroin, but by the fact that they'd crush pills and inject them without properly filtering them, and the pill binders caused heart damage. A clean supply of heroin and access to addiction treatment would have prevented their heart problem.