Nobody discusses these mundane drawbacks when they talk about the evils of heroin addiction. When you're high, you puke and you cannot give a shit. Both figuratively and literally.
As for "depress your respiratory system", yeah, in high enough doses, or if you are especially sensitive to it.
Pharmaceutical opioids are pretty much safer than NSAIDs. The side-effects of NSAIDs are actually worse than the side-effect of opioids. You will not get ulcers, blood clots, stroke, heart issues, GI issues, and all sorts of other issues with opioids.
[0]https://www.addictiongroup.org/drugs/opioids/morphine/overdo...
The instant antidote is Narcan which is available over the counter at pharmacies in some states.