You'll get like 1 or 2 HP difference maybe.
It's mainly for the sound, where you get that gain (mid range or high range). The gain however might be minimal, unless you decide to go with header and exhaust as the same time.

Check feedback on this forum:
https://www.honda-acura.net/forums/search.php