I've been driving a manual transmission so long it is second nature. The first car I ever drove was a manual. The best manual gearbox still belongs to Honda and I was actually considering the Accord Hybrid until I found it was automatic only.
I prefer manual for several reasons. 1) It usually, but not always, get better MPG. 2) I have more control over the vehicle, which means I always more alert, and 3) It prevents many people from wanting to drive my car since many people don't know how to drive a manual. No computer or machine can give you to control of a manual.
Personally, I think it is a shame that drivers' education only teaches on automatics. Everybody should be taught how to drive a manual.
In my recent column, Tranny talk, I wrote about the why I like double clutch transmissions. What kind of transmission do you prefer, and why?

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic