I distinctly remember an opioid removing my pain. It could have been removing the concern about the pain. "Happy Juice" it was. It is easy to understand how people would become addicted.
Back and neck pain has been with me for decades now. It makes life un-enjoyable. There are indeed few options.