Sleep number bed vs. memory foam

Any recommendations? I’m ready to give up inner-spring mattresses and I love the idea of a sleep number bed because of the flexibility, but I’ve read some pretty damning cons. Memory foam holds no appeal for me because of the heat retention and the sinking, but I read tons of rave reviews.

Anyone have experience with these beds? Any thoughts?