You only want an automatic transmission if you:
1) Spend all of your driving time in stop and go traffic.
2) Have a drag race car. (in which case you have a high stall speed torque converter and manual valve body)
For all other applications a manual transmission is the only alternative.
fixxed
For us solo1,2, and DE' junkies I think the old fashioned stick and stomp(clutch) seems be working quite well.
I love manual trannies, they make even the lamest of vehicles somewhat entertaining. Winding through the gears and revmatching on down at lights/traffic. I've had more fun driving old 80's 5spd civic's then my friends auto vette for that very reason. Keep in mind that I say this because the public road is NOT the place be using a vette for what it's worth tempting may be sometimes.