Looking for a guest bed for occasional use with three goals:
Comfort for ILs and my parents as they will be the primary users... Older folls, you know, i would like for them to be comfortable, not a college kid crash pad. We like them

they'll be here a weekend every other month, max (everyone lives locally - this is solely for convenience).
The rest of the time we'll be using the room for catch-all... Christmas gifts, sewing/craft projects, etc. So I don't want a full size bed (Q, K not possible) limiting other activites.
Don't want to spend a ton, but understanding comfort and durability will increase price somewhat. We are viewing this as an investment, but would hate to make a PB level investment only to realize it's a sucky uncomfortable bed!
Suggestions? Not opposed to murphy or sofa beds, as long as it really is reasonably comfortable for kind loving grandparents in their 70's!