"Spirited Street" means different things to different people.
On this 96, if the brakes have served you well up to now, you have no problems with warpage, the rotor thickness is above the discard dimension and there are no grooves in the rotors over .015 deep, I'd leave the rotors on the car.
As for pads, if the brakes have served you well so far, I'd continue to use 96 Grand Sport pads.
There can be a noticeable improvment in pedal feel if you replace the stock rubber brake hoses with braided stainless-steel covered hoses. I got the ones on my 95 from Doug Rippie. My other cars use Aeroquip hoses.
Now, if you're going to replace your rotors with something you feel is capible of better performance, slotted rotors are always the better choice. Drilled rotors, unless they are rotors intended to be drilled in the first place, will crack under aggressive use. The best stuff comes from StopTec but, admittedly, they are expensive. No doubt, there are less expensive rotors but cheap rotors are that way because of cheap materials and rotors made with cheap materials tend to warp more easily.
With brake pads you walk a fine line between brake performance during aggressive driving, cold brake performance and rotor wear and, if your a show car type, brake dust.
For spirited street use, I prefer a fairly soft pad. For street driving, I'll take some brake fade under really hard driving before I'll take reduced brake performance in emergency situations on the street due to cold brake pads. In this case stock is ok. A slightly more aggressive pad which also works well when cold, is the best bet but, again, the good stuff is darn expensive. Right now my favorite is either the stock GM 96 pad or the pads marketed by Aaxis under the "Ultimate" brand. I'm sure there are others---like spark plugs, everyone has an opinion about brake pads.
When you change the pads or rotors remember to flush and bleed the sysetm and use at least a good DOT4 fluid. I like Valvoline Synthetic but, I admit, there are better (and more expensive) choices such as Motul DOT 5.1.