The engine isn't built for one or the other...the chassis you put the swap in is what determines what is easiest to use. Your car came with a hyrdo so use a hydro tranny...there are plenty for sale right now, a few are really nicely priced. No kit needed

92 and up civics use hydro
94 and up integras use hydro

anything before these use cable (including crx)