We much prefer manuals this side of the pond. But I bought my first automatic this year. I've grown to quite like it, but then I drive my manual and I'm reminded how enjoyable driving can be, almost like the car is a part of you (excuse my cliché)
But I recently took my auto to a city, and I can see the appeal, it's one less thing to worry about when you're not entirely sure what lane you need at what junction, and can concentrate fully on directions. And if traffic is bad, depressing and then holding the clutch in multiple times may give your lower leg fatigue.
So, figure out your personal situation, and base your choice on that. For me, on near empty rural racetrack like roads, it's manual all the way. I visit traffic infused cities once or twice a year, an auto is not worth my time.
DSG's are heavy because you have two clutches, higher maintenance and can be problematic too.
__________________
|