On YouTube there are a bunch of videos with exhaust features on 'Vettes. Pretty much you will find all manufacturers represented by what the owner installed on his/her car. Keep in mind the audio will limit the true sounds that hearing live can only provide...but the videos actually helped me make up my mind.
In June, I bought and had installed on my '06 VR convt automatic, the Borla "Type II" Agressive.
Very nice, deep, throaty bass about town...with a hint of highway burble to slightly let you know you have Borla's installed. Over all...what a sound!