Mattresses are such a subjective and personal choice that there just isn't a one size fits all answer. My wife can sleep on feather bed or a piece of lumpy ground, so I get to make the choice.
As we were in the market for a new mattress for the master bedroom at home, I took the opportunity to replace our new Eagle's mattress with an adjustable air mattress to get an idea as to whether I'd like it or not. After pricing and checking reviews I went with an 8" queen Comfortaire. That's their cheapest one, but when we bring in the bedroom slide, the mattress has to fit several inches underneath the vanity top.
So with about ten nights on it I went with a better model in a king for the home. We've now had it about nine months and it's just great for me.
I chose the Comfortaire over the Sleep Number based almost completely on price. You've probably never heard of Comfortaire but know a bit about SN. Both are old companies but one spends a whole lot more on advertising. I think that accounts for all of the price difference.
Customer service has been great. Comfortaire seems to have just a very few CS people, so working with them on the order and asking for suggestions and advice seems a lot more like dealing with a face to face sales person than a faceless CS. SN may be just as good, I haven't worked with them.
I did spend several minutes a few times on, or in a memory foam bed and didn't like it at all. Being a tosser and turner, it just wasn't for me. You might love it.
As for innerspring units, I think, my personal opinion, I think that all of them, up to the $3000 level anyway, are junk. Just the fact that they're impossible to price compare because each brand has different model names for every retailer tells me it's a con. Hundreds of model names, but probably only a handful of truly different construction specs. Not to mention that the $3000 unit is "On Sale" for half that most of the time.
'11 Eagle 320RLDS
'02 F350 PSD Dually 4WD
DW's Ride, '13 Expedition