This is a really cool comparision table, comparing 14 effect categories of the 6 mostly used drugs (Alcohol, Amphetamine, Cannabis, Cocaine, Opiates, Tobacco).
Example: in the category Deaths worldwide:
Alcohol: Millions yearly. Mostly caused by heart and liver diseases, accidents and belligerance. Relatively few fatal doses.
Amphetamine: Thousands yearly. Mostly caused by belligerance and irrational behavior.
Cannabis: Thousands yearly. Mostly caused by police actions and accidents.
Smoking: Millions yearly. Mostly caused by lung cancer, emphysema, heart disease, reduced resistance to infections and a few by fire.