Ours is very comfortable. I can walk in the mornings, again!
Mikeeee
If you would like, I can give you a code for a little discount. PM me and I will look up the number for you.

We just stayed in a hotel this past weekend that had them. It was ok...ok at best. I wasn't overly impressed. I guess I had a good night's sleep, but I brought my number down so low, it was in the teens. DH had his in the 40's.
Maybe others will chime in and have a different experience. For the two nights we slept on it, it didn't make me want to run out and buy one.
Consider a waveless waterbed then.
. So I bought the same mattress they had at the Dolphin. Worked ok for a year or so.... now I can't get comfortable. Back kills me.
Dunno what to tell you. You sound like me, i.e., very selective about your sleeping surface. I really don't think you're going to be happy with the sleep number bed. Sorry.
We've had one for 17 years...bought the first one right after the company started. Gave that one to our soon as it is a Queen...replaced the pump (at their expense) once...replaced a bladder (air mattress) once at their expense.
We now have had a King for 5 years. Not one problem and it's been moved (as in from house to house) three times. LOVE THEM!. Definately get the middle leg(s). Also always get two controls. Do NOT get the "feather top" thingy. If you need more, go to Target or someplace like that and buy a $70 memory foam topper.
We love our bed. I adjust mine when he's in bed as I'm much lighter than he is. I sink in when he's not in bed. But when both of us are there...we sleep like babies and that's hard to do at our age with the aches and pains normally associated with 60.
I'd recommend a Select comfort bed to anyone!