Honestly I prefer the latex mattress we recently got to the sleep number beds I've slept in. I knew heat would be an issue for me so I stayed well clear of the memory foam options.
The nice thing about latex mattresses is they allow for different firmness levels on each side of the mattress. While not as easy to adjust as a sleepnumber bed they come in layers that can be moved around or even exchanged. Our is a three layer 10" mattress. My wife is firm, medium, soft layers from bottom to top while I am a firm medium medium. The cost for a queen with foundation and two pillows was $1850 which is much less than what I would think what would be the comparable memory foam sleep number option (starting at $2600 on their website)
I used to wake up with some lower back pain on our pillow top. Also, if I slept on my side I would wake up with a very sore shoulder and likely a numb arm. Now I have no back pain and no arm numbness. Occasionally there is a slight shoulder soreness but no even close to what it was before.
I also find it to be slightly cooler than our pillow top and much cooler than even the 'gel infused' memory foams I've tried. Next to no motion transfer either. FWIW I enjoy sex on it more than the pillow top too
Supposedly another big benefit of latex is that it won't break down as quickly as a pillow top (or even memory foam but to less of an extent). They use less chemicals than other mattresses if that matters to you. They are also supposed to be hypoallergenic although I remain skeptical since it still has a cover. I did notice my allergies cleared up a lot but I suspect that would also be the case with any new mattress at first