By far the most harmful drug was alcohol. I might be confabulating, but IIRC some government officials in the UK even asked some of the researchers to downplay some of their findings, because it basically showed the ridiculousness of government drug policy.
Regardless, though, the details of the report itself are worth a read, as I think they fairly assessed harm across different criteria, e.g. harm to oneself vs. harm to others.
https://www.thelancet.com/journals/lancet/article/PIIS0140-6...