This is the bed in my youngest’s room:
As a couch, it isn’t great - deep. Since they are in college, I keep thinking I’ll make some back cushions to shorten the depth for when they aren’t home, but I haven’t done it yet.
As a twin bed its pretty comfy. Pulling out the trundle and separating the mattresses gives you two mattresses so you get the divot between the two, but the mattresses fit tight on the frame, so it isn’t really noticeable.
The trundle is a little difficult to pull out on the carpet - but we only do it a few times a year for guests. When the kid is home, they use the twin.
And the drawers underneath are really nice.
In my experience, you’ll use the couch in the office if you work from home some much more often than you’ll use a bed. Curling up on the office couch to work is a nice feature of a home office.