Honda Pilots are 3-row, very reliable, and get good mpg for what they are. They're kind of vanilla, but well engineered. I'd say the Pilot and CX-9 stand out in the 6+ passenger SUV segment. You can check the data on this site, but the Mitsubishi, Hyundai, Kia, Nissan and domestic offerings in this segment won't generally have the same reliability as these two. And consequently, depreciation should be best for the Honda, almost as good for the CX-9. If the Pilot isn't snazzy enough for you, there is the Acura MDX which is similar but nicer.
There aren't really good car-like 6+ passenger options. I believe you've got to go back to the Ford Taurus wagon from pre '06 for a 3,500 lb-ish 6+ passenger car. There's also the 05-07 Ford Freestyle which would be significantly below your price range, but is also more car-like (still 4,000 lbs). The subsequent wagon/crossover offerings with that many seats (Benz, BMW, Volvo XC90, Fords Taurus x, Flex; probably missing some here) are about as heavy as the Pilot (4500 lbs) and will cost you more per year to maintain and keep on the road than a comparably priced Pilot/CX-9.