Most modern sewing machines have capability to do so much more than you probably really need.
Personally, all I really need is a machine that can do straight stitches with adjustable stitch length and reversing. I have a 1950s machine that does that, and it was free to me, and there's attachments for zigzagging if I want.
If you are just patching and altering clothes, that's probably all you need, too.