My Superb is the first DSG I have owned and I thought long and hard about the paddles, in the end I ordered them and I am glad I did, for overtaking on single carriageways they are great, yes you can pull out and floor it letting the DSG shift down automatically or you can manually shift down (without taking your hands off the wheel) with the paddles as you are about to pull out meaning you are already in the right gear for a swift overtake.
Obviously those who just want to follow the car in front will not find them anywhere near as useful... if at all, it is all down to personal preference and how you drive.