I recently spent several days sleeping on this, and slept extremely well each night. While I had looked at a lot of reviews before deciding on this model, it was still surprising just how comfortable it was. I was originally interested in the 'coil' kind, but decided on the noncoil kind after looking at the reviews--and am very happy with my choice. It also inflated and deflated easily and fit back into the bag (and box) without any hassle.
The space available fit a double-size bed better than a queen size, so it was nice to easily obtain a double as that's not a popular size. I ordered a double rather than a single as it seemed that a single would have been on the narrow size for one person, and believe that was the right call. One caveat: It can be challenging to get up from the bed if you have any significant physical limitations (a comparison would be getting up from a sitting position on the floor) so, if you want the bed for use by someone who would have trouble getting up, you may want to get the kind with the additional foundation or arrange that something (e.g., a chair) is conveniently placed for them to grab on to while getting up or down. I didn't get the higher one as I didn't want the extra bulk to store, and would just arrange for a solid piece of furniture to be nearby for use by anyone who might have trouble getting up or down from this without something to hold on to.
It held all of its inflation throughout the seven days I used it. I do have friends whose AeroBed suddenly developed a leak (cats may be involved!), but am expecting that no such thing happens to this for many years based on the high number of positive reviews.