I had a guest room mostly filled with a double bed, and a small desk/shelves/filing cabinet along one wall.
It was very cramped when using the computer so I often brought it downstairs to the dining table, but it was then in the way for meals.
I had a very small sewing room, filled with shelving and a table wedged under the window between the shelves. It was OK but quite cramped.
I have had one overnight guest in over 4 years and have bought a sofa bed. So decided to make the best use of the house for me but find some solution for guests if/when they come.
So I donated the guest bed, and have just ordered two of these.
I have switched the study and sewing rooms over. The folding mattresses will probably be seating in the study. The table in the study has removable legs. So if guests come I will move the computer, take the legs off the table and move it out the room, unfold the mattresses and give them a private space.
I also still have the sofa bed in the living room, so can host up to 4 people if needed, but have more space for my computer and sewing all the rest of the year. I think a happy compromise.