If a new mid-range model is not within your budget, you could also look for an older, used model. My Vintage 1958 Husqvarna cost me €40 from Facebook Marketplace and it’s the best machine I’ve ever worked with. Normally I’d say go to thrift shops and estate sales but of course that’s not really an option now. A basic old machine may not have fancy stitches and cool features but they often sew like a dream.
My main machine is a Bernina 801 from the early 1980s, my mother bought it as a newlywed, they are €250-ish now if you buy them refurbished from a sewing machine store, they can be found for less. It has about 10 different stitches, it makes buttonholes, the feed dogs can drop, it can stitch through several layers of fabric. That’s enough for most people’s needs.
My friend has a Silvercrest machine and from the “cheaper” brands that’s supposed to be the best one, but I’m not impressed with it. So far it still works and it has a lot of cute stitches, but the tension is always slightly off and it makes a weird rattling sound.