If you are looking for good mileage, a few cars ago I owned a deisel Jetta. Got me 50+ mpg and I put 360k km (~225k mi.?) on it. It was a pretty utilitarian vehicle back then, but like everything else it looks more upscale these days.

Now I cohabitate with a wife, 3 kids and a dog so have gone the minivan route. Might try to for a big car or wagon next time. Only show stopper may be my wife. She has a bad back so doesn't like stepping down into a vehicle and climbing up out of one.