I recently got a new (and hideously expensive) memory foam mattress. I have to say that it does make me feel less sore in the morning.

That said, the mattress before it was a cheap piece of crap, so it's possible that anything would've felt like an improvement.