This is such a loaded question with so many variables.
I got a v6 auto. Why? Because speed was not my goal. I wanted cosmetic mods. I have a few power upgrades, like MRT2.0, CAI, and TB. Everything else is just looks. I got the automatic since my wife can't drive a stick. That is my only regret. Not my wife, but the auto.
You're going to have to think hard. Whats the little man in side you say?