A straight through type muffler will have less restriction than a chambered type.
You will get better power and gas mileage.
No miracles, but it WILL breathe freer.
At the end of the pipe, you are not really tuning, but removing a cork.
Yes, it will be louder, but usually only a problem when...