As far as prestige from women's point of view, I think Mercedes, BMW, and Lexus take the cake. Those are the brands that everyone knows is expensive even if you know nothing about cars. I've talked to women who know nothing about cars and they never heard of Acura, Infiniti, some haven't even heard of Audi, but they all know Mercedes, BMW, and Lexus.
I want a car that's nice and stylish, but I also want good bang for my buck. For non-luxury brands I think Hyundai and Kia offer the most for the lowest price, and also have the longest warranties. I think the Hyundai Sonata and Kia Optima are stylish and come with a lot of features for a small price, but I'm also a fan of the Nissan Altima, and I love the Acura TL, Lexus IS, and Audi A4, which I can afford, it's just a matter of if I want to spend that much on a car, or spend that extra 15k on some nice trips. I don't think spending over 50k on a car is ever a good idea, I personally would never do it, there are so many other things I can spend my money on, and you start to worry about every little scratch and dent, it's not worth it.
It's really hard picking a new car with so many options on the market.