I already have a few older machines, including a FW, that I use for classes, and a machine that I keep downstairs (quilt room is upstairs) but if I needed something like you're describing I might look for an older machine in a cabinet, so I'd have the workspace as well as the sewing machine. I'd love to find a Singer 301 in good condition.
That said, I've heard really good reviews on the newer inexpensive Janome and Brother models.