By modern standards they are pretty slow, but with bolt-ons you should be able to run mid 15s without much effort. Intake, exhaust, and header and you'll put ~125-130 to the wheels. With a tuning solution that will be more like 135, maybe 140.
They don't have a ton of room for tire so you cant easily run 9" or 10" wheels like Miatas can. 15x8 with a 205 or 225 is very easy though and fits well. If you are going to a more prepared class and you can run R compounds you can do the work to make bigger stuff fit.
As mentioned above, the engines are quite durable as long as they have oil in them.
If you want to build a motor, you can make a frankenstein engine from different engine parts throughout the years and make a little more power. IIRC the intake manifold is the main restriction. The heads actually flow ok and should be able to make significantly more power than real world results seem to reflect.
They handle boost o.k. but not great. Not like a BP. The ringlands aren't very thick, so you have to be careful with your tuning. There are people that have put down a reliable ~220hp on 7psi or so. A lot get greedy and turn up the boost eventually and blow stuff up. If you put forged internals in there obviously you unlock a much higher ceiling.
The trans has a weakness where if you like to do burnouts the diff pin will loosen (case around it expands due to heat) and fall out, grenading it. If you weld the pin (not a welded diff), they are fairly bulletproof. Quaife and Mfactory both made helical LSDs, but I doubt they are available anymore.
Regarding suspension: The stock rear swaybars are all the same (if present). There are aftermarket ones floating out there, but not sure if any still made - unlikely. Coilovers work great, but if you cant find them, look for H&R Race springs. If you can't find those, the stiffest you will find are H&R sport, which are decent, but probably not going to cut it for competitive autox or anything with R compound tires.
The front suspension has a weird swaybar/toe link setup where you can't remove the bar, so you just have to live with it. It has not-great bumpsteer characteristics.
Overall the biggest weakness is that everything you can do with one you can likely do easier with a different platform where the buy in is only marginally more, and far less time/energy/money than you would need to spend make custom components for a Saturn.
This was my old daily, and I actually miss it quite a bit. It was a good combo of useful and fun to toss around, reasonable mileage, and zero berks given about it.