Moreover, it only harms your veins if you shoot it.
It is addictive and tolerance forming, but that's about the only downside.
Let's take myself for example. I have a good salary and used to spend maybe 40k/year on heroin. That's a big cost for sure, that's why I quit. But because I could afford to do it, there weren't any other downsides. In fact, there were a lot of upsides.
I worked harder and longer than any of my coworkers could even dream of. I could pump out high quality code for 20 hours straight. No one knew I was addicted to anything. In fact, over the 2 years I was addicted I got promoted and got huge bonuses every year for being a quote "killer".
People think the common social effects of heroin (stealing, homelessness, etc) are inherent to the drug itself, but that simply isn't true. These negative effects have more to do with the laws and culture we have built up around the drug, not the drug itself.
Nitpick, but, heroin hasn't been ruining lives for "centuries." It wasn't even invented a hundred years ago.