I've got a Kenmore 385 that I've used for everything from upholstery vinyl to stretch fabrics. I used it to make seat covers for my brother's car as well as every one of my costumes. Crazy easy to use, and still works great after having been in the trunk when I was rear-ended. My sister has a Brother that used to be my mom's, but it was constantly in need of repair (stupid drop-in bobbin setup was always having problems).
At school, we've got a Bernina 1008, a Singer from the 1940s, a New Home, a Juki, and a Bernina Industrial. Of those, the Bernina 1008 and the Singer are the two everyone wants to use because they're simple, straightforward, and will work with just about everything you throw at it.