I bet we are not hearing the stories about all the healthy and functional heroin users mostly because it's illegal and socially unacceptable. It means public only knows about cases when poor people abuse it too much. Rich guy? You bet public never knows if he does it occasionally or did it a lot then went to rehab and recovered.
Yes, you can also get terminally addicted to ethanol and ruin your life. I've seen people like that. The biggest difference is perhaps that these people don't just destroy their body, ethanol abusers also tend to hurt or murder other people when they are high on the substance.