The black one is a muffler -- just that. It doesn't give notably better engine performance than a stock muffler, although it weighs considerably less and has slightly less frontal area.

The tuned pipe is a performance enhancing tool for particular applications. It can boost HP quite noticeably, but in a narrow RPM band. It ain't an everyday exhaust system.