Foam and latex mattresses mold to the contours of your body for personalized support and both materials absorb movement. I think these types are the best. For example I have Ultimate Dreams Eurotop latex mattress at home and it is very comfortable! I found it review here sleepmentor.net/best-latex-mattress/ it is good top pick from former salesman.
I also prefer comfortable mattresses! Memory foam is better then latex but latex seems to be expensive. I purchased sleepissimple.com/folding-mattress/ folding one. It's really comfortable to sleep and I don't feel back pain after night. Honestly, some people prefer different types, it's individual and you can try different options.