All these Nissan SUV's had a major problem with the transmission cooler inside the radiator leaking and result being destruction of the transmission. Class action lawsuit resulted and Nissan "slithered out" of responsibility with clever lawyers. Result was only a fraction had a small portion of the actual cost covered. Very few of the thousands of affected Nissan's got a small percentage of the cost covered. The real sad issue is that Nissan did everything possible to NOT stand behind their products. It is an unhappy tale that so many thousands of Nissan owners were abandoned when this problem happened. Even the dealers are ashamed of Nissan.
Regarding MPG on my 2008 Pathfinder S 4x4 with automatic transmission. After two years and 28K I consistently get 18.5 mpg mainly around town and usually with a small mix of expressway/freeway driving. I use 87 octane only. A/C or not it gets the same mileage. On trips I've averaged 23 mpg. Hope this is helpful. I chose the Pathfinder over the 4 Runner because of the deal. About four thousand cheaper and the base 2008 4 runner didn't even have the 3d seat as standard. Towing capacity was 1K more than the V6 4 runner. So glad I picked the Pathfinder.
I own a 08 LE and an 1998 LE pathfinder. The 08 has 16k miles on it and the 98 110k. They both are great but absolutly not comparable. The LE also has the navigation and DVD package. I never was able to achieve better than 12m/g in the city in any condition in the 08 where it is 16 m/g on the 10 years older PF. My 39 m lease on the 08 will finish in 7 weeks and I will bargain buying it from Nissan Bank. Having said that I am definitly pleased overall. But I still prefer the built and drive of the 10 years older PF (08 is built on a truck frame while 98 is a car based SUV). I find that nothing is plastic inside of the latter and the plush carpet and in it are better quality.
We test drove a Chevy Tahoe, a Toyota 4Runner, a Toyota Highlander, and a Nissan Pathfinder. The Pathfinder had styling, comfort, and plenty of room inside. The only negative factor we've discovered is that it tends to wander at speeds above 60 mph. No problem with transmission as described by other owners.
I have had my Pathfinder for a little more than 2 weeks. Absolutley love it. The engine is a monster, just plain fun to drive! Gas mileage is what's expected. If people are concerned about gas mileage, then stay away from higher displacement engines... nuff said. If people want to complain about the legroom in the third row, upgrade to a bigger car. I have yet to sit in the third row of any midsize SUV and feel comfortable. It just comes with the territory. I am more than satisfied with my purchase, and hope to have this car for years to come.