I have the Janome MC6600 P. And it's about 12 years old now and never been a problem. I bought it because the biggest local quilt shop sells them and services them. Felt if they could endorse Janome then they must be good. I also love my Singer 15-91, it is 73 years old and works well for straight stitch sewing. I have the button hole attachment and another attachment called an embroidery attachment, they are a royal pain since the Janome does a lot without the hassle. And I have a Viking Designer Topaz 20 which is an embroidery/sewing machine. I use it mostly for embroidery. So it all depends inwhat you want it to do and how much you want to spend. The Janome was $1500.00 when I bought it on sale. It came with the table it sets into so I didn't need the extension table that came with it. The Viking was a floor model at the dealer's and was around $2,000.00. It would have been more had I wanted one in the box. Oh, I have a Singer Featherweight that is from 1947- I bought it from Shopgoodwill.com. It is my travel machine. I got it about 12 years ago for around $200.00 and it will use all the attachments I have for the 15-91.
If you like older full metal machines and a local repairman, he probably has some for sale. They were bought up when COVID hit and everyone was making masks. A lot are now back in the thrift stores and are great bargains.
My sister had a Brother machine she bought from Costco many years ago - it lasted her for years. And everyone I know that owns Brothers love them.