Just thought I'd throw in my tuppence worth!
I ran an 2007 Passat R32 DSG for a couple of years as a company car and imo the gearbox killed that car. In town and D if you rolled up to a roundabout say in 2nd gear, too little throttle and it would change up to 4th and leave you with nothing under your foot, too much throttle and it would bang down to 1st and rev its nuts off leaving everyone thinking you were a twit. Putting it in S just made the throttle far to sharp and jerky so it was driven in manual mode most of the time which kinda defeated the purpose.
I reckon a manual gearbox would have much that car brilliant. The engine sounded stunning, it handled great but I just ended up resenting the DSG.
I appreciate that this was the first of the DSG's appearing so the electronics are probably much more advanced now but the car also ate 2 gearboxes and a mechatronics unit, which had you been unlucky enough to buy it out of warranty would have cost ££££s.
Currently my own car is a manual and my company car an automatic and I wouldn't change either. A lot of my day to day driving is in town so the auto is perfect for that and then heading home in the manual suits that type of driving.
My advice to the OP as others have said is to try and get a test drive in both. That will either push you one way or the other.
If your still undecided then think about what the majority of your driving consists of, and finally if your still sitting on the fence there's small matter of the cost of DSG. If your not too fussed is it really worth the outlay.
I think DSG is a kind of marmite option at the end of the day, its just down to what the individual likes!