We have a small house. My sewing room is the living room, along with all the other uses for a living room. I keep extra fabric in the third bedroom and try to keep things somewhat neat in the living room while I'm working. We currently have 3 vintage machines in cabinets in there. I sew at one and use the top of one of the others as a cutting table. The third machine is used when I want a zigzag or decorative stitch. If I need an extra or larger work surface I have a fold-up table I can use.
Use your space how you live. I think I do more sewing because the machines are visible and convenient.
Rodney