I'll lend you my experience...I went from a 5 speed to an auto and back. There's good and bad about each, but if you like to driver then a stick is the way to go. Here's the breakdown:
Stick - Good: manual control - you choose your gear.
more fuel efficient
better acceleration and overall performance
it's something everyone should know
Bad: sitting in stop and go traffic
requires some practice -- zero idiot factor
Auto - Good: your grandmother can drive it.
conducive to cruising...or laziness
Bad: poor acceleration
worse gas mileage
no "control" over what gear you're in -- every auto is different, but if you're gonna shift it then but a stick.
What really swayed me to get another stick is when I'm merging on the highway and I need the transmission to kick down a gear. I get a big time lag before the kickdown -- this is in a 2001 Focus. I like to be in control of my car and feel what happening -- I also lucked out in that the only car with anti-locks was also a 5 speed!