Just sold my
Ibiza Bocanegra DSG for an S3 manual, the DSG system was flawless in terms of smoothness,quick changes and if you have a very stop-start commute it can be slightly better than a manual but even that is debatable. One thing I did find very good about the box is that if you're wanting to get somewhere fairly quickly and can't be bothered really trying it's good for just pointing and shooting.
however it's very dificult to take off at speed as you have to sit with your foot on the brake to stop the car creeping forward on tick over
I hate kickdown cutting in and changing down gears when I just want to accelerate a bit harder and stay in the gear I'm in
The car felt very artificial compared to a manual on a set of country roads when pushing on a bit and it did feel a bit like control of the car was reduced-maybe that has something to do with my last two cars being an a3 3.2 manual and an R26 but I still felt detached
To sum up my opinion, if you are looking for a car to have fun in and are the type that would go out for a drive-purely for a drive then manual is what your after, but if you're looking for a car that makes pretty rapid progress through the gears and gets you from A to B with minimal fuss then DSG is where to spend your cash.