Go sit in a late model S (eg 2018 or later) and you’ll know if the seats work for you, as the front seats haven’t notably changed except the ventilation feature. The rear seats are the big change.
I have a bad back as well, and the bigger change for me sitting in the refreshed Model S is the new adaptive suspension, which is even better than the adaptive suspension in the Raven generation.