How much you willing to spend?
All my clients seem to have mattresses from Hastens and swear by them:
[Link: hastens.com]I'm not exactly sure how much they cost, but the high-end models are over $100k according to the guys delivering and setting them up.
I've slept on two different Hastens mattresses for a few nights each in guest houses and they were both quite pleasant. I think these were lower end models that cost much less. It's hard to describe, but aside from being comfortable they just feel luxurious... kind of like sitting in an Aston Martin with all the nice leather.
Spending some dough on a good mattress is money well spent, especially if the bed is good enough quality to last a long time.