Damn that sounds rough. Definitely sounds like your issues extend past just the mattress. You’re definitely right that there is only so much a mattress can do if you have back complications. It’s worth seeing a doctor if you haven’t already.

Have you tried foam mattresses? Sounds like you have, but if not maybe it’s worth a shot.