They don't exist. Any giant SUV looks pathetic by definition. Then you get into which sleek sports car drives better and looks good. In terms of "car hotness", I have a weakness for Lotus, personally, but in my neighborhood I see a lot of Porsches and a few Ferraris.
But if I were in the market for a middle class family car, I would get a Japanese model known for reliability and easy maintenance - Toyota, Honda or possibly some types of Lexus.
Finally, if your husband wants to look hot coming out of his dashing Rav 4, he needs to be muscly and debonair