There are prescription drugs with side effects that cause real second-order societal problems (OxyCodone and related opioids are one the come to mind immediately). Amphetamines can cause psychotic behavior (see https://en.wikipedia.org/wiki/Stimulant_psychosis for an accessible read). If the person using and abusing those drugs were isolated from others and couldn't harm them it would be one thing but they usually aren't.