Opioid overuse can cause depressed respiration (slowed breathing), which can cause permanent brain damage or death. Studies have shown opioid use can deteriorate white matter in the brain, which affects decision-making capabilities, among other side effects.
While the effects of opioids in particular are dangerous, there are dangers with any type of prescription drug, and they should be used only as directed.