At the end of the day it comes down to each individual. There is no right or wrong answer or one better than the other. Like many have said you cant make a decision on whats best (for you) if you haven't even tried one, and im not talking about a 15 minute test drive down your local stealers. DSG is much more complex than an old school auto box, over time you adapt to it and it adapts to your driving style. Comparing any gearbox to another is wrong let alone a DSG unit to any auto. You wouldn't say the BMW m3's manuel gearbox is pants, not because you have tried it but because the manuel box in a Kia Picanto is carp. You can only compare what is best for you in the same car.
Not that it matters what i think but i have owned a manuel GTI, a DSG R32 and now a DSG Pirelli. I also spent alot of time in a DSG Gti and a manuel R32. The combination that suites me and i like the best is DSG Pirelli/GTI and the R32 in manuel.
This is what makes the world a great place we all have different tastes otherwise we would all have the same haircuts and walk around in the same clothes having all driven the same car.