I notice most of the posts not in favour of the DSG are from manual box owners
If you liked the DSG box on a test drive then chances are you will really like it if you do for the car, it's the best of both worlds, you can be lazy, leave it in D and let it do it's business which usually means it will fly through the gears quickly not getting above 3k revs. One more click down on the stick and you're in S which really holds on to the gear up to the red line if you're pushing on, gives a nice blip of the throttle on down shifts and makes the car feel quite aggressive.
In manual mode you can either use the paddles or the stick to change when you want (it will step in if you really need to shift gear in a self protection kind of way).
Ultimately a DSG equipped R is quicker 0 - 60 than a manual R due to the much faster shifting.
I collect my RS5 next week which has a 7 speed DSG, I don't think I would buy a car without it now, that's how much I like it and I am a hater of auto boxes.
Do it, you'll love it.
RS5, Scirocco R. You can never have enough R's