This is why it's so personal. C2K was obviously not overly impressed, but I had my first DSG on my previous Scirocco and loved it. It was the first option I ticked on the GTD as I think it suits it's character really well.
The Diesels have a relatively limited rev band (compared to petrols), and it's very easy when setting off to find yourself near the red line in first unless you snatch quickly for second gear when rolling (I remember this from my MK5 Golf GT 2.0 TDI). With a DSG gearbox, it just handles the gears so much better and makes smooth fuss free getaways so much more relaxed.
Coupled to that, most of my life is spent churning though rush hour traffic with the inevitable crawls and the DSG just makes this so easy. I guess if I lived somewhere like Scotland and didn't have many hold ups and had some fantastic roads to regularly blast up and down, I might (just might), be persuaded back to a manual, but as it stands, I can't see me ever going back to one.
The downsides are obvious that it's a considerable chuck of money to spend (that could be spent on other options or just saved on the purchase price), it needs a oil change service that the manuals don't, and is obviously more complicated, so whilst the 6 speed DSG wet units seem pretty bullet proof (touch wood), statistically, there is more to go wrong.
As I said at the start, it's a deeply personal thing and one that only you can really answer, but I have no issues with those that prefer a manual over a DSG, and it's their choice (just not mine).