yes, you are correct, d series are older civic engines, but it was a good design so they kept it...
newer civis had the D17, not really the same deal as the older D's but a D nonetheless...
https://hondaswap.com/forums/index.php?showtopic=29825
this link is for the motor list...
it tells you which motors came in which cars, what years, and whether they were USDM or JDM...
JDM = pricey and harder to get...
you wanna first look at the code column and look for any B series motor...
of course you have to decide if you want a cable B series trans, which greatly limits your options as any cable b series besides the early integras = JDM...
or if you want to buy the cable->hydro conversion from hasport...
one of their b series kits includes this conversion, and this conversion will open the door for you to use any year hydro trans = a lot more options and better chance of getting one for cheaper...
ignore the late 80's early 90's preludes with B series motors as these are bastard B's the B20 will more than likely NOT bolt to any of the prelude B series trannys
https://hondaswap.com/forums/index.php?showtopic=29829
now this link will take you to a brief synopsis of the gearing for the transmissions...
so once you find one from the above link, and you wanna check to see if it will work for your goals, check the gear ratios and such...
hmotorsonline.com is a good resource for buying motor swaps, they will also be a good source for a cable tranny if you decide to go that route...
cheapest B series will prob be the cable tranny from the early integras, but i dunno if that gearing is what you're looking for... also remember LSD is a nice thing to have... but it costs more...
hasport.com is the place to go for some quality race mounts/shift linkages/cable to hydro conversions, wire harness conversions etc etc etc
they have instructions for every mount kit they make on the website to give you an idea of the work involved, and its always more complicated than it looks lol
you should check the prices for the cable to hydro conversion so you can figure that into your final purchase price of whatever trans you go with...