Magnaflow offers an excellent y-pipe with cats. It's 2.0" which is good enough for up to 300rwhp, is mandrel bent stainless steel, and it includes high flow cats. The only thing is, for the 94's you can only get it as a system (all 3 cats). Most of us ditch the 3rd cat so it sucks to pay for something you might not want to use. Nonetheless, that is the only decent y-pipe out there.
Y-pipe.
Then the only cat back exhaust I recommend is the Flowmaster kit.
Cat back.
If you ditch the 3rd cat you'll want to get the resonator that goes with this system.
Resonator.
Not cheap when you consider that is about $700 for the two pieces, $880 with resonator, but you are getting quality stuff that will sound good and fit well. You can also go to an exhaust shop and take your chances but I think you'll find that you spend nearly as much and you'll have no assurances as to how well it will fit or what it will sound like. Lots of people on here have gone and had local shops fab stuff up or even fabbed it themselves, but in many cases the end result is not as nice as the internet might lead you to believe.
In this case you are getting all mandrel bent piping, stainless steel y-pipe, and a system that will not only sound nice but will support as I said up to 300rwhp efficiently.