I'm sure Vogz will have some good insight. But here is a little of what I have seen when researching them a couple of years back...
The IMS bearing is a big potential issue in those era N/A cars. If you can do the work that saves a lot. But the kit and tools can still be expensive. I remember reading that early engines had some issues with cracking cylinder liners. But not sure if that is internet lore more than an actual high percentage of owners who experienced that issue. And I am sure by now it would have been obvious by anything other than a car that has sat for the last 10-15 years.
Aging wiring, vacuum hoses / hard lines, leaking rear main seals, ignition coils, and the usual stuff that are of concern with any 15-20 year old car.
The front ends have no weight to support. They usually last forever. The rear gets abused some but usually no major issues. And replacement parts are not too expensive or hard to replace.
Like any car, good maintenance history is a huge benefit when buying these cars.