Probable gains below (note that this is with K&N panel filters and smooth tubes for both sets of runs)
You will not need a tune, although getting one may net a bit more power. The above dynos are, I believe, with the OEM tune and cats.
See more dynos and lots and lots of exhaustive analysis and discussion on the H-pipe Nismo (and other mods) here
Proven Power Dyno Database Thread