For most people with long term pain an opiate prescription is the wrong choice.
The patient ends up with an addiction of opiates; while taking dangerously large quantities of opiates; while still being in pain.
They've still got the pain; they now have two additional problems.
Most people with long term pain need access to pain management services which include other stuff (exercise, physiotherapy, weight loss, psychological therapies) as well as (if needed) opiates.
Except that the primary focus of pain management services seems to be overwhelmingly about reducing opiate intake, rather than helping the patient deal with pain.
Maybe there are no good choices for some long term pain.
I don't know where you are, but in England most pain control clinics are mostly about helping the patient deal with pain, and using appropriate medication to do so.
Here's the English guidance for managing pain in non-specialist settings, so this is what people should be getting from a regular doctor. (For neuropathic pain).
Why is it that opiate addiction is seen as far far worse than debilitating chronic pain? Why can't the patient make that choice?