I bought an Infiniti QX4 new in 1997. Basically the same truck but the QX4 has a more sophisticated AWD system. IIRC, the 4WD system on the Pathfinder was your more traditional part time, shift-on-the-fly set up. LSD was an option so you might want to check for that. No AWD was available on the '97 Pathy.
Trouble spots seemed to be exhaust system related; loose heat shields that rattled, cracked exhaust manifolds, etc. Rear suspension was soft and allowed some bottoming out when loaded. Overall its an excellent vehicle, made in Japan, very high build quality.
The 3.3L V6 puts out a wheezy 168hp, its torquey but not powerful. The Pathy weighs over 4000 lbs so your 0-60 is over 11 seconds and you'll be lucky to see over 20 mpg. 15-18 mpg is common. Runs on regular fuel. Upside is the 3.3L is tougher than nails and will last a very very long time with good maintenance.
The comparable Explorer has a roomier, more functional interior. The Pathy is great for two people and their stuff, but cargo space is limited and rear seat room is tight. Not great for large families or frequent passenger use. I'd consider the Pathy to be among the more refined and better made mid sized SUV's of the 90's. My folks just bought an '03 QX4 as a 3rd vehicle and they love it. They look at it as a luxurious large wagon with all weather capability for two people. That's what it does best.