If you like auto's, you'll love the DSG. If you don't like auto's, it probably won't change your mind. Think of it as a very good auto with non of the torque convertor downsides and you'll be very happy.
Things that put me off:
1) I potentially run our cars to 100,000 miles and there just aren't enough high millage DSG cars around to know how reliable it is. I'm not saying it isn't reliable, but you know where you stand with a high millage manual and the local gear box specialist down the road.
2) I was trail breaking into a decreasing radius corner in a new Golf GTI DSG when it decided to change down a gear
. Don't be fooled by the "its used in the Veyron so must be good" line. That gear box has an extra gear, can cope with four times as much torque and probably costs more than an entire Golf GTI.
3) You can't do heal-and-toe down changes which IMHO are the most satisfying aspect of driving.