smart ass answer: define "increase".... 0.1 hp or 10 hp?
that said, the hp increase will be meaningful if coupled with other mods, just by itself, might do very little, good chance to loose low and mid range..
BUT, and its a big BUT, an aftermarket exh can bring big weight reductions, good for acceleration, handling, braking.
the livelier sound is a plus or a minus, depend son you, were you live, your neighbours...