Methamphetamine is much less frequently prescribed than other forms of amphetamines for ADHD, but I wouldn't say "extremely rare". And there's very little evidence it's any more addictive or harmful than normal amphetamines.

I also think you're conflating addiction to dependency or withdrawal symptoms. Physical withdrawal symptoms are extremely common with stimulants - then again, they're common for basically all other drugs too. Adderall, caffeine, hell, even Tylenol all have withdrawal symptoms. If you're a daily coffee drinker, going a day without will likely cause a splitting migraine and some personality changes for a day or two! Many OTC nasal sprays for hayfever are known for having ferocious withdrawal symptoms, but they aren't addictive or abusable.

People who abuse stimulants take a dose vastly higher than any therapeutic dose. The effects end up being very different. You mention heroin, but heroin itself was originally marketed - for years! - as a non-addictive alternative to morphine, and was sold as a cough suppressant. Many people used it; most didn't get addicted. Cocaine was a fairly common additive to drinks for years; Thomas Edison was famously a fan of https://en.wikipedia.org/wiki/Vin_Mariani (as were two popes and numerous other famous figures).

There's nothing magical about heroin. Prescribe a therapeutic dose of a strong opioid, and maybe 1% (the data here is bad, but most studies cluster around this point) of your patients will get addicted and start abusing it (by taking a vastly higher dose); the other 99% will not. We keep demonising drugs, seemingly almost at random, but it doesn't seem to have much to do with the nature of the drugs.