Unfortunatley, sound is going to be subjective to the user.
One guys "awesome", but be another guys "ho-hum"
Also, take into consideration how the rest of the system is going to change the sound
Adding a particular cat back to an otherwise stock exhaust system is going to sound differently than it will when that same cat back is added to a car with an off road H-pipe, or X-pipe, or long tube headers, or larger diameter exhaust, etc. Engine changes (big heads, cam, power adder, intake, etc) will also change the way an exhaust sounds.
Your best bet it to hit up Youtube and start going through the video's.
I've had Mac,
Flowmaster,
Magnaflow,
Pypes and even went with a set of '05-up stockers on my Fox for a while before I finally found the right ones.
I finally went with the
Borla ProXS mufflers in my system after going through hundreds of different sound clips, before finding
this video and selling me on them. They sound fantastic with my
BBK LT's and off road X-pipe and don't drive you batty with resonance drone on the highway. Couple that with the fact that the price was right and
Borla's stainless steel quality construction is second to none and a previous impossible decision for me became crystal clear.