I can drive both manuals and autos, and the manuals can be fun, but really. For the usual drive to and from work, maybe out to get food, in city driving, I like autos a lot better. There is much less mental usage needed to drive an auto. And when you're stopping and going a lot in heavy traffic, manual can get annoying.
That being said, if I were buying a sports car for weekend cruising, I would definitely get a manual, but for regular Joe Schmoe driving in town, auto is my choice.