I had a Acura TSX Wagon. It's a great car for the purpose you described, but the gas mileage wasn't very good. Overall, it's really a Honda Accord stationwagon they sell in Europe so it's not as really a luxury car.
I like then look of the new Volvo S60 wagon, but again, gas mileage has always been pretty poor for all the Volvo wagons and I don't expect this to be much better.
The Audi A4-based All-road is a car I really liked and probably would consider if they ever bring the TDI version into the US.
The others, even though they are not market as station wagons are: BMW X1, Toyota Venza, Lexus CT200h (the one I am driving now), Subie Forrester.