aftermarket stock resonators are a very good idea- coupled with a larger pipe and a nice muffler you will have a very nice sporty sounding exhaust.
i have gone through a couple different brands of mufflers, and i am most pleased with my magnaflows. they are very reasonably priced, and very high quality. talk to sean at
www.ctmotorsport.com if you are interested in buying one of these mufflers- he can get you a great deal.
if you want to hear how my car sounds, here is a sound clip..
http://zoni.freeservers.com/rev1.mp3
the loudest thing when i redline it is my intake- the exhaust is fairly silent in the cabin. just a nice low rumble up to 1200rpm, and then it mostly cuts out. good luck, and feel free to ask any questions about my setup!
jon