new tranny? manual sift?

Hi All, As a total noob here and to cars as project hot rods I am asking is there a "hammer simple" solution to all of the issues with these automatic transmissions? Is there a better alternative in a 4 or 5 speed manual shift with a clutch? What are the benefits and the drawbacks? I need...