It doesn't matter whether it's a sports exhaust or not, It depends on which exhaust is matched to the engine (or the other way around).
Small example: if you build a super hyper extreme exhaust on your car, but this has too high a back pressure, the performance is more likely to decrease.
The other way round. If you take a "normal" exhaust, but it is matched to the engine, you increase the performance.