What's a good sewing machine for someone who wants to do basic sewing?

I want to buy a decent quality sewing machine. I am not quite a beginner-level sewer, but I am far from experienced and have not sewn much in the last 10 years. I want to sew things like curtains, make pillows, stuff like that – basic stuff, nothing too complicated.

I had a Singer but it was at least 20 years old and spent a few years in the basement, unused, and a friend who is somewhat of a sewing machine expert said it’s rusty and I’d be best to get a new one. She told me she does not recommend newer model Singers nor does she recommend Brother. She said she suggests a used Kenmore.

I think Costco has some, and I know Amazon has them too. I’d even go to a local sewing store, if they had one that was decent.

I am looking for a new machine, preferably not used, and all suggestions are welcome.