I think the consensus is an aftermarket tail pipe may look better, almost certainly weigh less and plays a better sound track.
Swapped in isolation it will have a negligible effect on engine output or characteristics, people will state (myself included !) it feels free revving , uncorked, breathes better etc etc.
I can’t recall a dyno chart that backs this up though.