Just a little of my own experience, which going by the previous comments, I'm in the minority.
I had a dsg equipped a6 recently as a courtesy car while mine was being serviced. I personally wouldn't willingly have one.
It was fantastic at the driving auto and the sport mode was quick, faster than I could change in a manual, but it was just missing the engagement and felt like a playstation game. Very point an shoot.
In a manual you can feel the mechanics of a car, really push it to the edge, not forced changes.
I found it annoying getting on my drive because there is a slight upward incline to get onto the drive then a downward slope. So in my car I just balance on the clutch to get up the incline then release and roll down.
In the auto, it stops on the incline at bite and doesn't move any further, so I apply the throttle and nothing happens for a second and I'm nervously waiting for the power, then the auto box would suddenly release it clutch and I'd be flown onto the drive having to brake hard. It was the same of reverse getting off the drive.
Then there was pulling out on roundabouts. If I needed to pull away reasonably fast it was either all or nothing. If I pushed the pedal half way I'd have to wait too long for the power to kick in and I wouldn't get away quick enough. Or I would put my foot down and absolutely fly off the line. No in between.
Then I've heard about reliability and issues if servicing hasn't been kept up with (not an issue on a brand new car but risky on second hand) and torque related limits.
I'm not trying to slag dsg off in any way because I think it's an engineering masterpiece but it's not for me.
I guess I'm a control freak!