There are many threads that answer your question. A quick forum search will reveal all of life's mysteries.
some threads even include videos so you can get an idea of the sound for various exhaust systems.
Having said all that, I recommend the exhaust that you like the looks of, sounds of, and suits your budget best.
Also, welcome to the forum