We have used two bed-in-a-box and been quite satisfied. We so missed our tempurpedic that we recently changed to one of them. We full time so finally bit the bullet. No foundation was needed because 6 months ago I installed an adjustable frame. It took some modifications but it sure is nice.
Even if you have a short queen you might be able to use a regular size. Things could be a bit tight but might be worth measuring.
We have to raise the end of the bed before pulling the sides in. Just a bit but it is electric so not an issue.