Replacing Mattress with Foam ?

I am considering replacing the cheap queen mattress with 4" or 5" thick foam. Has anyone done this? I sleep in the overhead buck and sleep great whereas my wife sleeps in the corner bed and says the m...