When my daughter moved into her one bedroom apartment (she had been in a tiny studio) I bought a top-of-the-line Aerobed. It's for ME when I come to visit so I no longer have to stay in a hotel!!!
I have a VERY bad back (two surgeries) and find the bed to be very comfortable. It gives me enough support. The only "trouble" I have (and should have bought the one higher up from the floor) is entrance and exit. But that is me, I have trouble bending.
I do find that I need to sleep with sweatpants and socks on in cooler weather because the air in the mattress feels cold to me and I freeze!
Don't buy a cheap one, get a good one!