I have headers to straight back
I have hooker competition (equal length) headers going straight back and ending in some Cherry Bombs.
It's not loud until you get in the 3500RPM range. It's execpetionally loud in the 5000+ RPM range. But when you are revved up that high, there's usually a reason, and the sound only adds to whatever excitement you are going for.
If you are considering an X or Y-pipe, you'll want to research it, as they have different performance benefits.
I have sound clips of my car if you want to hear it. I thought Scott81 had them on his site, but I was just there and didn't see 'em. Lemme know if you wanna hear 'em. If you don't like the way Cherry Bombs sound, check the DynoMax Bullits. They have a pretty cool sound as well once you open up the car. Otherwise, they are pretty tame.