Eh, it's a case by case basis. I'm currently prescribed d-amp, I've put a whole bunch of scary opioids through my body for fun, and have used pretty much everything else under the sun more than a few times. I'm also pretty cognizant of "addiction logic" -- Especially when I'm doing something bad, rationalizing it, feeling worthless, and recognizing my own bullshit all simultaneously. In terms of "addictions" aka "inappropriately falling in love", this a log scale ranking of how much unhappiness they've caused from high to low:
- Internet news / information, including this website has a worse effect on my life than anything else. I can't get anything done right now, but if I were on dope I would still be doing something productive simultaneously. My internet usage can get to the point of refreshing the same 10 webpages for an hour, etc. No acutely deadly potential, but it happens literally all day.
- Video games. More so when I was younger. You can imagine.
- "Working" -- Has led to loss of friends, relationships, health, personal growth and making money!! Just like sex, this is not about all work but about inappropriate patterns of work.
- Certain types of sex and romance, e.g. the type where one doesn't want to see the person again or ever be seen with them in public. Mostly just lost sleep and self-worth, but very often.
- Stimulants -- Sleeping, relaxing, and zoning out are really nice, much nicer than being on speed all the time. But they enable the "working addiction" to a much unhealthier degree than it could get by itself. My "I must bang out a project over consecutive 100-hour days until it's complete to my standards" is the equivalent of your "parties that turned into a week", kind of. Less bad than low quality sex because it's less frequent. Changes in my work habits could make it worse, though.
- Heroin et al -- Pooping, eating, sleeping, having sex are really nice. Being on dope all the time, or even a lot of the time, isn't nearly as nice. On the other hand it has been very attractive to me in times of romantic upheaval due to the no sex drive thing, but it's more "luxuriating in depression" and sex eventually regains its old place in the desire hierarchy.
- Other drugs -- Not really on the list. Sometimes I will use them but it is always kind of a chore.
Having some experience with "addiction to hard drugs" is nice because it provides a model system for the less clear-cut types of addiction. However, there seems to be an inflection point at which the pros of a balanced life no longer outweigh the cons of an addicted life and it can be tricky to learn how to navigate around that point. Most people I know who love drugs in moderation have always been doing pretty well for themselves in a material sense, anyway.
Finally, to fill out the list, here are a few other addictions that have totally wrecked the lives of people I know, but which pose no danger to "normal people".
- Gambling
- Exercising
- "Controlling" one's own diet and physical appearence
- Feeling anger
- Going fast in cars and motorcycles