We bought a sleep number bed about 10 years ago. we paid $1500 for a queen. I didn't really care for it. If your sleep numbers vary a lot between you and hubby, don't expect to be able to snuggle, each side of the bed has it's own bladders so you can pump or deflate according to your preference, in between is what I liked to call the "great divide" no snuggling for us!!! I liked my side very soft so I was in a valley, DH liked his firm so I had to go "uphill" to get to him, he had to roll down, it was funny at first but really grated on our nerves after awhile.
We now have a wonderfull mattress, sadly I don't remember the manufacturer, but it has a temperpedic (sp?) type pillow top I LOVE it!!! It's just enough cushion for both of us.
I've heard but, not my experience that the all foam mattresses get a little warm since you've created your indention and then surrounded by foam??? Not sure, maybe other who own them can comment but my foam top doesn't make me hot or retain heat that I've noticed...