We got a Tempurpedic Cloud about three years ago. At first, my lower back started to hurt, but that's because our old mattress had zero support. Over time, it worked itself out.
Now, I love that thing. My wife is weird about it, and she says she prefers one with springs, but it's the most comfortable bed ever.