I have 3 bad discs... one lower back, 2 neck... so... I feel your pain...
1. I've slept on a sleep number bed a few times.. back when I was traveling a lot and one of the hotel chains had a deal with them... they were not adjustable base models (no foot and head height adjustment), only adjustable firmness... I remember the first time I ever laid down on one.... I messed around with the firmness, found something I liked (around 60, IIRC) and thought.. "Ok.. I'll close my eyes and see"... It was daylight out when i closed my eyes and I woke up when programming ended on the TV and that annoying "snow" sound started. And I hadn't moved from where I laid down.
2. Wife and I discovered that we prefer memory foam mattresses. A good quality foam will conform to your body and support you all over. If you are heavy in the caboose, that part will sink a bit more, but the foam will fill in at my lumbar to provide support and I can sleep without pain from my bad lumbar area. Wife has had a similar experience.
3. We recently stayed at an AirBnB that has the most comfortable mattress I've ever slept on... It was "Gel memory Foam".. whatever that really is..We actually stripped the bed to find the manufacturer information. Turns out it was a China import and we eventually found it on Amazon. We were heartbroken to find that it doesn't come in a tall enough height for our bed... it would leave a gap between the headboard and mattress.. our pillows would not be happy.. If they made a 12-14-inch version of this mattress, we would have slept on it last night...
LINK.
I guess what I'm saying is... figure out what options you think you might like and find a way to try them out before buying...
Select Radison Hotels have Sleep Number beds... Maybe seek one out next time you travel?
https://www.pruvo.com/blog/hotel-beds-w ... best-beds/
Radisson
The Radisson group offers “Sleep Number Beds” by Select Comfort. These mattresses allow the firmness of each side of the bed to be adjusted. So, if you like a softer bed but your partner prefers a firmer bed, you can both get an ideal night’s slumber. These mattresses are available in selected Radisson hotels only, thus, it’s wise to consult the hotel prior to your arrival.
You can get into a very good memory foam mattress for a relatively low cost... Both Zinus and Ashley have solid reputations on Amazon. Our daughter likes her Zinus, Wife and I are sleeping on an Ashley that we like a lot.. The Ashley King 12-inch medium firm is currently $400 on Amazon.
Good luck my friend... I hope you find something that works well for you.