My parents sell each year real heavy bed frames with 30/39 inch memory foam mattress, it is as comfortable as a folding bed can get, plus they last years. I know people who have it for 10+ years. I will get more info and pricing in a bit...
Update?
@coffeebean ?
@Something Fishy?
Yes?
https://www.amazon.com/gp/product/B0073WJACW/ref=ppx_yo_dt_b_asin_title_o00_s01?ie=UTF8&psc=1We own a few of these. DH is over 6 feet tall and his feet don't hang over the end like the previous one we owned. The mattress is thin but the cot adds comfort. Folds small and is easy to store. Bonus: it's cheap enough to buy one for everyone who needs so there's no fighting.
Link doesn't work for me. What's the product name?