I bought an auto one time because I needed a car at short notice and within a mileage and £££age budget and it fit the bill, it just happened to be an auto.
To be fair, I quite enjoyed it. Yeah, there was some lag at times and all that but i'm not Tiff Needell so didn't worry that I couldn't "work up through the gears" and the engine was still big enough to "make progress" so it never bothered me - the upsides of never having to change gear far outweigh those downsides.
So I enjoyed it so much, when I had a bit of a bigger budget I bought a VW Scirocco 2.0 TSI with a DSG box, complete with flappy paddles. Now THAT was seriously a fun drive that allowed me manual control over the gears so I could go back to "Working my way up through the gears" and allowed me to "make some serious progress" when the road conditions allowed for progress making. Even on those twisty country lanes it performed amazingly, much progress was to be had.
The DSG was a vast improvement over the first box, with a lot of lag eliminated. A much smoother drive. I don't own a car currently (moved to city) but if/when I buy another one I wont hesitate to get another auto.
Sitting in traffic is much simpler without having to bugger about shifting all the time, also.