My son has one and sleeps like the dead. When my daughter wakes up in the middle of the night screaming (for whatever the latest reason is) he just goes right on sleeping. I slept on the TP once but it was damned hot.
I've been on a Sleep Number since it was called the Select Comfort...must be going on 15 years now. The only time my back hurts is when we wake up in the morning with another body in the bed with us (like my daughter) and I have "adjusted" to a ramrod-straight posture to accommodate her sprawl.
The only problem with the SN is that I lost the battery door to the remote, so the battery is held in with duct tape now.
FYI for a good night's sleep I need:
0) Laying on my left side
1) Pillow between my knees/ankles to keep the pelvis straight
2) Pillow (or wife) under right arm to keep ribcage expanded
3) Down or down-like pillow under my head (left arm goes under the pillow to keep the shoulder from popping out)
Sometimes I wish I had access to zero-gee sleeping plates like in Larry Niven's Ringworld books.