I bought my Pathfinder brand new in 1998 and it's still going strong 220,000 miles later. Cabin held up well and still looks great. Things to watch out for: real axle seals (leaked, had to have both replaced), fuel throttle body (replaced, was sticking from bad fuel and had a coolant leak), AC (replaced compressor, replaced fan speed switch (x2), replaced blower motor and its speed control resistor (x2), harness wires toasted from being too thin), and that coolant rubber hose inside the engine (!) that gets overlooked when replacing the timing belt, water pump, and other hoses.) All-in-all it's been an AWESOME truck for me! Definitely buy one if you can find one that's been well maintained.
Great value for what I paid, at the time a comparable Toyota 4Runner was $10,000 more. Other than that, I enjoyed having this SUV for the utility it provided. It was great having it after the bad '04 and '05 hurricane seasons - you can go over almost anything with this truck!
Judging by the things that have failed over the years, Nissan needs to work on certain subsystems to improve their reliability. Beef up the electrical wiring harnesses. Higher power engine (was improved in subsequent model years).