Nothing wrong with automatic. Some of the fastest eclipse's are automatic. You just need to beef up the trans/axels if you want to race.
Since you are just looking for some extra umph, I'd suggest the typical I/H/E. Unfortunately Hondata Reflash won't work on your car since its not manual.