I weirdly always found Naproxen much more effective than ibuprofen but also find Celebrex great which seems to further confuse the whole COX 1 vs 2 situation

Recently, I've had to take Celebrex (celecoxib) for a back injury and I've been taking it longer than is normally recommended—and that truly worries me (I've determined I have to come off it ASAP).

Where I am (Australia), most doctor's prescriptions that have to be taken long-term are issued as the first script plus five repeats. Not so with Celebrex, a script can only be dispensed three times (3 x pk of 30 200mg capsules — one per day, for 90 days max) and scripts can only be dispensed every 21 days. Reason: Celebrex is only recommended for short-term use because it's considered a dangerous drug with possible irreversible side effects if taken for too long.

This was not news to me even before taking Celebrex, way back in the 1990s I was prescribed its sister drug called Vioxx (rofecoxib) for back pain and it was much more effective than Celebrex (at least it was for me).

Anyway, sometime around 2000 I read an article in the journal Science about a significant statistical increase in deaths by heart attack, stroke etc. by those talking rofecoxib. At the time I said to myself it won't be long before Vioxx is banned. It took another three to four years for that to happen as Merck Pharmaceuticals fought the decision every inch of the way. It's worth reading the Wiki about this (when it's between a drug company and millions of dollars profit patients come off second best):

https://en.wikipedia.org/wiki/Rofecoxib

What's relevant here is that the related drug Celebrex survived because its side effects—whilst manifestly similar—aren't quite as bad as Vioxx. In short, Celebrex's COX-2 selectivity versus other less selective NSAIDs like aspirin (which target both COX-1 and COX-2) was deemed sufficiently beneficial despite its potential serious side effects.

Note: I'm not offering medical advice here and you should always take that from your medical practitioner. I mention this because only several days ago I had a discussion with two younger doctors who'd never heard of Vioxx let alone the Vioxx/Celebrex controversy.

You may be interested in this YouTube video on Vioxx. Unfortunately it's over hyped and designed to alarm but it's essentially factually correct: https://m.youtube.com/watch?v=K0GrFnOpJoU