Less extreme are antibiotics which can also have bad side effects, but are useful drugs because they actually kill bacteria. If they did not, the side effects would be unacceptable.
Or should the government make that decision for on-label uses and doctors make that decision for off-label uses? That's the status quo. Whatever argument you have for one half of that is an argument against the other half.
This is exactly how doctors determine what works, with or without the government. See the off-label discussion in the link above.
I'm not suggesting that current regulation by the FDA isn't flawed, or that it doesn't need an overhaul, but I think it's clear that there should be some proof that efficacy studies were done before a drug becomes widely available, especially when the potential damage done by a failed treatment is so high. The current opioid crisis has completely eroded any faith that the pharmaceutical industry is capable or willing to regulate itself.
Specific suggestion: get rid of efficacy requirement, keep safety requirement. Let doctors decide what works, as they currently do for off-label uses just fine.