Back to your original question - "yes", you will see some gains in a different exhaust. There's a recent thread on this issue already, but I don't feel like digging for it, so, here's my take on the issue. The stock single muffler system is not mandrel bent, and the muffler itself is restrictive. Not to mention it sounds extremely weak, and especially by today's exhaust standards.
IMO, the Hooker catback is the best bang for the buck! "Yes" there are better overall systems out there, but nowhere near the price of the Hooker. It's a very nice mandrel bent system with high flowing straight-thru mufflers. Comes with all necessary moutning hardware, and the fit is excellent! I was very impressed at the ease of installation, requiring no welding, and can be done by one person. The only help I sought was for someone to help with evening the muffs out. (one to lay under car and adjust, and the other to sight in the view from the back).
It has a unique sound. It's not too throaty, but is very crisp. It doesn't make much noise at all until you stand on it, and then it perks up and buzzes nicely. My system came with a cat-converter replacement pipe (offroad use only

), and its general design will help HP by default. It's not stainless, but it is aluminized, which will last a very long time, unless you leave it submerged in a pool of salt water...
Cheap alternatives --- have your factory muffler cut off and just run straight stock diameter pipe out the back. It'll be louder than the Hooker, but it will certainly free up the flow.
And of course, if money is no object, you can get a nice ATR system, but be prepared to have your head spinning from the heavy drone at 2400-ish rpms. Good power though.