I have an '06 Pilot. It was not my first choice, but I absolutely needed something that seated 8, and it was my best option at the time. My use has been a little non-traditional, since I was the nanny for three families concurrently, which meant I had six or seven car seats in there (not an easy task, let me tell you.)
With all three rows in use, the trunk is minimal. Depending upon what you'd like to haul, there's not a ton of room... I could get a nice umbrella stroller in there, or some groceries, but that's about it. Flip the third row down, though, and there is TONS of space! So if you only need the third row for occasional use, it will be fine. Both the second and third row fold down, quite easily, although the headrests do have to come off of the third row in order for it to fold flat. (They stow under the floor of the trunk.) Gobs of room with both rows folded down. Both rows are 60/40 split, although good luck getting two adults on the 60 portion of the third row!
I did take a trip about two hours with seven adults -- two up front, three in the middle row, and two in the third row. The two in the back reported it to be uncomfortable for that length of trip, but it is the perfect size for upper-elementary aged children.
One very nice feature is that there are headrests and lap-shoulder belts in all positions. This is common in brand-new cars, but even a few years ago one or both of those elements was missing. With those features, you can actually safely transport eight adults. (There are also tether anchors in all rear seating positions, very unusual but very handy, in case you have carseat-aged kids, but since your son is 6ft that's probably not likely!)
MPG-wise, I drive a combination of city and highway and get about 320 miles on my tank, which is 18-19 gals to fill it. If I drive exclusively highway, I can get 24mpg or a smidge better. Adding in any city driving at all absolutely kills that, though.
I really like the drive, radio/climate/etc is very nice, the stereo controls are in the steering wheel (important to me, personally.)
Hope that helps
