SN95's are honestly surprisingly solid. Sure the Fox chassis DNA is obvious down there but I feel like Ford did a great job optimizing them, and it's pretty surprising what you can get done with basic spring+shock upgrades, and especially if you get into additional stuff like panhard bars and subframe connectors. I've driven plenty of Fox, SN95, and New Edge Mustangs making 1000+whp and if it's a drag car you want, they do great there. But for auto-x and most SCCA classes and similar handling-oriented builds, ~400whp is about as much as you'll ever need - or be able to make, depending on the class rules. With modern rubber and suspension it's surprising how good those older Mustangs can do at racetrack games.
But regardless of chassis, cars north of 1000whp just make the world really small and are honestly hard to enjoy in most street settings. You need a BIG gap in highway traffic or a basically deserted on-ramp and highway to really whomp on them at all. It becomes harder to enjoy and it's just a game of balancing worries - eyeballing gauges to make sure the crazy beast of an engine isn't overheating, nervousness about traffic/unexpected road hazards/cops/etc.
The struggle with 90's cars or old muscle cars is that dumping even half that HP into most of them make them wildly unbalanced as a car. The suspension, brakes, etc are all terrifying for anything genuinely north of 500-600whp in most cases. So all of those factors need to be addressed as thoroughly as the engine build itself, but few really do that.
Once that's handled, my personal favorite threshold for most RWD cars is ~750whp or so. Modern top-shelf performance tires and thoughtful selections with suspension, etc can make it a genuinely driveable and enjoyable car at that HP level.
Much past that and you have to start making significant changes to the car for the sake of traction and straightline stability, and that rapidly starts changing the car from 'fun' to 'scary' or 'feels like work' to drive it.
Modern chassis like the S550 Mustang and others tend to do much better with boatloads of HP, but most of them bring a weight penalty as well, especially the Dodge stuff. Fairly common to see a ~750whp Vette walk a ~950whp Hellcat, for power:weight reasons as well as gearing and aero.
So for lightness, handling, simplicity, and just pure enjoyment - there's a shitload of value in the SN95 and New Edge Cobras these days, and @
Suvorov has a hell of a nice example!