it is very simple

Muffler- quiter, but also take out more power, moslty used in places where there is a restriction for noise.
Tuned pipe, longer, powerfull, more noise, usually sucks more fuel as well.

tuned pipe need to be adjusted properly, muffler no need to adjust.