Air beds can be comfortable in mild weather. When it gets cool they get cold fast. Makes my old bones ache. I have a couple of backpacking weight Thermarests but the best thing I have ever found is this in the XL size on a cot. Still fine without the cot and it's warm. Self inflating and easy to put away.
3.5" pad on my cot.
Want more comfort than this? Probably better off to stay home. These pads really are that comfortable!
KISS Principle = Keep It Simple Stupid.
Your best defense against Murphy's law!