The older Honda's used motor oil, the newer ones use a manual transmission fluid with different additives. The newer ones also caution that if you use to motor oil to change it as soon as you can. So, as usual, check the manual or ask the dealer what your model requires.
I have a 1998 Civic, and am running Specialty Formulations MTL-P. I am quite pleased with it.
My older 1990 used motor oil, never did anything special with that one.