Pain can be a great teacher but it also can be a ferocious and intense demon if you let it happen. At times we can't control the pain but we can do our best to avoid it as much as possible. For all intents and purposes, the no pain, no gain thing is a bullshit myth. Being in pain is not fun and when it hits hard, it can be debilitating. Been there, done that and not very fond of it.
I understand the need to be on painkillers, I did it while I had my sciatica and was so bad I couldn't walk. I hated taking them and made a conscience decision to stop. The real painkillers that are worth taking is to train doing mobility, flexibility and old fashioned strength training. It's not easy and you won't always have the best day but even a bad day is better than getting addicted to pills to numb anything. Trust me, I feel you and I sympathize but it's important to be as level headed as you can. Some people turn to CBD gummies which more power to them if there are severe cases but if you can find a way to put drugs or even alcohol aside, do what's possible to utilize exercise.
One of the best painkillers, is DDP Yoga. Modify your level and work around things if you can and build that flexibility and strength little by little. With consistent effort, it potentially can get you out of pain and make you feel like you can take on the world again. It did for me and made me strong again that I'm doing stuff I never thought I'd be doing at 40 like hoisting up 100+ lb sandbags, being more mobile than before and even getting stronger in certain lifts I haven't done in years. Hell, at a fair here earlier this summer, walked around with the family and there was the Marine Recruitment tent that had their pullup bar to test people. I hadn't touched a pull-up bar in roughly 2 years or so and weighing 240 lbs. I knocked off 5 chin over bar pull-ups. That felt great to do and apparently I did the bare minimum they gave a little lanyard. I'd say that's a win for not doing almost any pullups at all in a while.
Another set of painkillers is using various tools that utilize many muscle groups at once like Sandbags, Kettlebells, Mace & Sledgehammers. Sure it's best to use lighter weight to work technique and you don't need to go super heavy to get something going. Train for real world application, don't push yourself to the point of pain, do enough to satisfy a good workout and challenge yourself, progress little by little and keep yourself healthy.