Remember guys, this is a G2 Integra. That means cable, or a pricey conversion kit.
Your three real choices are first gen B16A (SiR, XSi, RSi,) B18A (normal YS1), or B17A (GS-R version YS1) Given this lineup, the stock B18A trans is the longest, the B16A's fall in the middle, and the B17A trans is very similar to the later ITR trans, very short.
I'd go with a B17A version YS1, though they are getting rare and very expensive.
See this link for the ratios:
http://www.bseries.net/html/specs/btrannyspecs.php