Generally, MFB is right, it wont make a huge difference, but there are exceptions. I think he was speaking in general terms.
We have seen some of SMSP and Hytechs offerings make 15-20+whp additions on otherwise stock motors. If youre going NA, youre going to need every bit of help you can get to make power. Header/cat/exhaust has gotta go.