First of all, before you get all exhaust crazy, what state do you live in, and do you have to smog? That will determine on what you can do.
Most people, including those in CA, generally go with a smog legal header, LCE and a few others make them with the CARB tag on them to show DEQ that it is compliant. Then a 2.25" pipe, with a high flow cat, and a decent muffler. I for one like my exhaust quiet. If you like noise, Flowmaster. This will give you the boost you are looking for, but it's not gonna be a huge boost. Alot of members clean up the intake, and put a mild cam in. Doing your intake, cam and exhaust, will definitely wake up the motor.