For smaller stuff the consew 206rb is good.
For larger stuff a cowboy 3200 up to a 4500 will do.
These are generic models of great machines of the past.
They are great working proven designs that last for years.
Now one could argue that you could take a machine like the 4500 or a cobra class 4 and "dumb it down" to do smaller stuff. And people have.
But, here's the potential problem with that: these machines are finicky at best. If you start monkeying around with one you need to be able to put it back to where it was before. They like to operate in a certain sweet spot within their specified range. And most, don't operate well at the extreme ends of their range. They have lots of adjustments on tension and movement. The tolerances are tight to make all those parts work in unison.
Once you start playing with one, you will be happy to get it where it needs to be and leave it alone.
The big machines offer too much pressure to operate well with small thread and needles. The small machines will wear out prematurely running larger needles and thread on the upper end of the tensions required.
Sorry my answer wasn't more informative before. I was short on time.