You'll gain a few horsepower, nothing major. Mostly it's for the look and sound.

Now, do you want it to be a little louder than stock or do you want it to be really freakin loud?