You are right - the question has been asked and answered many times. Everyone will give you their own favorite brand. You can search for prior topics on this in the search field on this board.
I will tell you to get a Pfaff.
The next person will tell you to get a Bernina
etc
etc
You need to figure out what you want a machine to do, take sample fabric with you, go to dealerships and try them out. You will find a machine that YOU like at a price you can afford.
Good luck in your search.