Any pipe with NO cats will net you the most horsepower gains...but if you're looking to use cats on it to keep it smog legal, an X-pipe will give more horsepower (not much, like maybe 2hp more) than an H-pipe will.
X-pipes are generally more "raspy" or sharp sounding
While H-pipes are more...