Recreational drugs can be highly addictive and lead to a loss of motivation for other activities, which is a key reason they are so dangerous, even beyond direct adverse health effects.
While all drugs carry risks, those with more noticeable negative effects, like alcohol causing sickness and hangovers, may be somewhat less prone to severe addiction than drugs that provide a "cleaner" high. However, alcohol is still highly addictive for many despite the negatives. Drugs that can cause fatal overdose even with a single use are the most dangerous of all.
When drugs are legalized, at a minimum there needs to be strong education efforts so people can understand the real effects and risks. For those who still choose to use potentially lethal drugs, there could be legal protocols for ensuring their affairs are in order such as a requirement to prepay their funerals.