On the more practical/attainable side of the auto spectrum, one of my favorite car designs of the 2000s:
It is not likely to fuel the wet dreams of teenage boys, but from a design perspective I think it was just about perfect. Neither beautiful like a sports car nor in-your-face macho like a Hummer, the Allroad was everything you wanted in a "go-anywhere/do-anything" car, and nothing you didn't. Offroad, it outperformed 98% of the ghastly SUVs that were just starting to take over the American auto market. Onroad, it provided the performance and polite road manners of a proper car, not a rollover-prone high-center-of-gravity glorified truck. It managed to perform in both settings thanks to a clever airbag suspension system, increasing and decreasing ground clearance as required. The drivetrain was based on Audi's instant-classic 2.7L twin turbo engine. The exterior design was German austerity at its finest. The interior was simultaneously luxurious, spartan, and intuitive, like all Audis.
This car was the pinnacle of the station wagon. It demonstrated conclusively that there was almost no reason for the average person to buy an SUV when a car like this, superior in every conceivable way, was available. It was the car to obliterate the myth of the SUV once and for all.
Unfortunately, it turns out that Americans just like riding around in big, heavy, high-riding trucks, because we are dumb. This is why we can't have nice things like the Allroad and the S4 Avant anymore. Instead, Audi now sells us monstrosities like the Q7 (shudder).