I have had 2 automatics.

I love autos as the car practically drives itself.

One was a Fiat Punto, there was no auto kick in as it has an electronic auto box, not too many around but I could take off at the lights quicker than anything it was a little flier.

Automatic Pros
Less work and to me a more enjoyable driving experience.
No heavy clutch so no stress on your left leg joints etc.

Automatic cons (as I see them)
More fuel thirsty
Auto cars start off a lot dearer new than their manual versions.
In Ireland there is not a lot of choice of autos especially in the smaller to mid engine sizes. For example certain makes don't do an auto version.
Less control especially if its snowing.
If the gearbox fucks up more expensive to fix.
If you want a car and it comes in auto, the engine size of the auto is usually bigger hence more road tax.

Even though the cons list is longer you can't beat driving a good auto !!!