They are extremely addictive. No one disputes that.
The actual drugs here - I’m talking pure, regulated pharmaceutical versions - are pretty benign physiologically. Constipation is about the worst of it.
The combination products (opioid plus something else) are a bit worse - but in those cases it’s the other thing (usually Tylenol) that’s actually hard on your body, especially the liver.
Although it’s much less common these days due to all the regulation, many doctors kept a up successful practices for decades while self medicating heavily.
What gets people killed are either things sold as other things (e.g. heroin laced with fentanyl, which is much stronger) or propel who quit for a while and then go right back to their old dose and OF because their tolerance is gone.