I find that very curious given my personal experience, and the experiences of family members. Since you made a summary statement on what the literature currency supports, can you provide meta-analyses that back it up? I have seen some research out there that says NSAID's and acetaminophen in combination can provide relief similar to opiods, but I haven't seen anything that approaches an overall conclusion that opiods aren't the best option and often lead to worse outcomes.
Most meta-analysis I've seen show that opioids prove better than placebo but are inconclusive in other comparison studies. The things I've mentioned were mostly seen individual studies and systematic reviews. A study looking at patients in the SPORT trial, for example, looked at outcomes for patients who were started on opioids vs those who didn't and showed higher surgical crossover in patients who were taking opioids.
As far as not being the best option, I've generally seen that radiculopathies/neuropathic pain responds better to meds like gabapentin, Lyrica, and Elavil. I can't point you to a particular study off hand, but it's been somewhat of a standard in the practices in which I've worked. In personal experience, I will usually start with an NSAID, steroid taper, or a gabapentin/Lyrica based on medical history and in some cases a short course of as needed opioids for breakthrough pain.
In issues such as OA/joint pain, opioids aren't generally seen as first line drugs, and I haven't seen any data suggesting that they are more effective in terms of functional gains, and the risks of adverse side effects are higher.
Regardless, a lack of evidence doesn't mean that something isn't effective. On top of that, I remain hesitant of studies involving pain scales, as I've treated people in acute sickle cell crisis screaming bloody murder in 10/10 pain and others who are smiling when they tell you they're in a 10/10 pain. Subjective scoring systems are deceiving, and I prefer functional outcome measures. I think opioids do show effectiveness in managing pain, and with careful screening and proper prescription, the addiction issue can be minimized.