I have a Husqvarna that I absolutely LOVE! It is the Sapphire 830. I also have a Kenmore(Janome) that is lightweight and easy to take to classes. Great for piecing.
I have a Singer redeye Treadle and a Baby Lock Emore for embroidery.
My cousin has a Bernina and she is scared to try the fancy features!! So I would say research, find ones with features you are looking for, and then go try them out at the dealerships.
Between everyone here, they can give you help with just about ANY machine you decide to buy!!!