To think a comfortable sofa bed doesn't exist?

[Flowersforalgernon1]

We live in a small 3 bed and all bedrooms are occupied so when we have guests we have limited space to host.
I bought a very expensive sofa bed from a reputable department store that is super uncomfortable as a sofa and need to find a new one. I feel gutted as it's such a waste of money for a useless expensive product!
I've done a lot of research but AIBU to think it's going to be near on impossible to find a sofa bed that's both comfy as a bed and a sofa?
I'm now looking at the Emma sofa bed.
Any recommendations for an everyday couch and a bed that would need to be for older generations to also sleep on?

We have a Loaf one and it’s brilliant. We got ours as an ex-display or seconds one as the full price would have been out of our reach, but it has an actual mattress (full depth rather than a thin foam thingy) and is lovely to sit on and comfy to sleep on. I’d really recommend looking for “Loaf seconds near me” online. They are quite soft and I don’t know if it would exacerbate your hip so you might want to try one in a showroom.

Definitely a futon from the Futon Company. The most expensive mattress type doesn't even need a mattress topper. It's so comfortable.