Exhaust is kinda personal preference like anything else. I have the T1R 63mm Sparrow and I really like it.
http://aj-racing.com/catalog/product...cat=106&page=3
Its loud enough you know its there, but not so loud you have to stop the car and get out screaming cause your ears are bleeding. It has a nice deep rumble. It does drone slightly at highway speeds, but not enough to be a problem.
If I had to do it again, I'd probably go with a Supersprint, its a little quieter, and I like the oval tips on it.
Heres a good place to start looking at exhaust. This isnt all of them, but a good start. And like s2000isu said, theres quite a few vids on youtube if you search.
http://www.s2000library.com/