I haven't been on the Dream, but the sofa bed on the Magic was comfortable. I laid down on it for a little while one morning and my only issue was how narrow it was.
In case you aren't aware, the sofa bed is not a traditional sofa bed. The back of the sofa folds forward revealing a bed narrower than a conventional twin.