Yeah, I'd definitely check about some banamine..
I went to the "urgent care" place once after I tweaked my back by almost* falling on ice the evening before.. By the time I decided I had to go for treatment the next day, it hurt so bad I couldn't get comfortable in any position and it actually hurt to breathe.. They asked if I drove there by myself...yep...asked if I had to work the next day...yep...so basically, narcotic pain meds were out. Instead, she decided to give me a shot that she said was "like super advil." In other words, a really stout NSAID shot.
Pretty much, I got a shot of banamine. I mean, I seriously doubt it was flunixin per se, but pretty much the same thing.
It stung pretty good, and I honestly didn't have much faith that it would work very well.. My thinking was "Hell, I coulda just taken some advil without having to get stuck in the butt...." but lemme tell ya.. By the time I got about halfway home, I was feeling so much better it was just unbelievable. By the time I actually got home, I felt like I was almost 100% again.
So, in a way, I can tell you first hand that a shot of banamine can do a lot of good.. And I say that not only as someone who's used banamine from time to time with his livestock, but also as a recipient of something very akin to banamine. It's good stuff!
See if your vet will get you a couple syringes.. Should be pretty cheap. I think the dosage is 1ml/100 in goats, but someone should double check me.
*I kinda sorta "halfway fell," if you wanna think of it that way.. Falling all the way down probably would have been much better, because when you almost fall, you can pretty much be assured that you've just used all kinds of muscles in weird and unusual ways to catch yourself. Not good!