By the sound you want, it appears that a Greddy Evo II is the best option. I have it and it is a great sounding and looking exhaust. It is a little more than $350 but you get what you pay for. It is also stainless steel throughout.
I would stray away from an axleback. Get a full catback for the best results. The piping on most aftermarket exhausts is 60mm or 2.36". The torque loss isn't bad and Hondas aren't known for torque, so you will be losing power if you go with a smaller diameter piping.
Check out this site for some sound clips (they are for Integras but you get the basic idea of piping size, appearance, and sound:
http://www.team-integra.net/sections...?ArticleID=451