I've had several manuals over my life and thought I'd give auto a go. I've now had two of different types and have some strong opinions:
VAG DSG (Seat Leon) - Only good once you're already moving. Changes are very quick and smooth, car was economical, and it was nice to drive on long journeys. When you're at a standstill or trying to do low speed manouvering it was crap. Jerky and annoying, especially when trying to parallel park on a hill. As it won't slip the clutch the hill hold would keep kicking in and you can't modulate it on the brake very much. The car would either go, or stop. There was also a reasonable delay when trying to pull away quickly. Was also prone to spinning the wheels as it basically dumps the clutch in first gear on quick getaways. Very frustrating in slippery/bad weather conditions.
ZF 8 Speed (BMW M240i) - Excellent at low speed manouvering and town work as it uses a torque converter. This means it's always trying to drive the car forward/backward and you can modulate it easily on the brake. Was also very good on the motorway. Less economical but not by much and the driving experience more than makes up for it. It isn't perfect by any means, when slowing down for a roundabout, if I quickly jump back over to the throttle and it hasn't made up it's mind what gear it wants, there can be a noticable and frustrating delay before it goes. Also the shifts from 1-2 on a cold start and light throttle can be quite jerky, but I've since tuned the gearbox and now in most scenarios it pulls away in 2nd gear, which is better. Pulling away from a stop is so much smoother in a torque converter gearbox.
Skoda Fabia auto (GF car) - This is an older, torque converter box. It's very smooth and has the same benefits at low speed manouvering as the ZF, which is perfect for my other half who isn't the most confident of drivers. I think the DSG would be too jerky at low speed for her to feel comfortable with parking etc. They're just easier and more predictable to drive.
My friend has had a Golf GTI and an RS3 and has the same issues with DSGs as me. Another friend has an A45 with a Mercedes dual clutch, and it definitely seems better than the VAG box, but I've not had any personal experience with it.