Your questions seem sorta general so you should do some more research and then come back with more specific questions as I'm sure some will be answered and you'll have a better understanding of things.if you are going to go turbo, start researching in the FI forum here on H-T.
as for the auto-to-manual swap, take a look in the FAQ. There is a how-to on a 94-97 Accord, not exactly the same but it'll give you an idea.
I wouldn't get just a cam gear without upgrading the camshaft as well. And if you are certain you are going to go turbo then maybe you should hold off on the cam until the turbo and get one that is meant for turbo engines rather than having to upgrade again later? just a thought...