I've always been more fascinated by opiates, they really sink their teeth into people. I'd never try them, I've never done any drugs, I've never so much as taken a puff on a cigarette. I knew back in my teens that I had zero interest in dabbling with that sort of thing, I didn't want what I considered to be "artificial happiness". One could argue that some drugs aren't artificial, but I've never been interested in using substances for joy, stress relief, ect.
That also applies to alcohol, although I do dabble in that. I've never wanted to use substances to cope, which is why I've never really been much of a party style drinker.
I've also seen and heard too much. I did a practicum at a reputable rehabilitation facility in Nanaimo, got to hear a lot of stories from a diverse range of people, people who were often much more educated than I was at the time. I worked on two different wet sites that had residents actively using as a support worker, I also put together harm reduction kits as a support worker and have observed folks being brought back with naloxone. I think the worst I ever saw was a guy turning blue, it took like three or four shots of naloxone to bring him back. Wasn't uncommon to see folks nodding off, or folks experiencing withdrawal symptoms.
I don't think it's uncommon for folks to attach a sort of mystique to drugs, but I also think most people haven't really experienced the gritty realities that often come with the territory.