Personally I love the DSG, it's my first one, and I took a gamble speccing it, but 100% glad I did.
Ok, it can sometimes be a pain in the ass - if you change down sometimes at certain revs it can be a bit jerky/clunky, and if you change down multiple gears too fast, it will take longer as it will skip one (so time it to go individually). Aside from that, its brilliant - the ease of no faffing when in a boring commute, to the speediness of the changes when you're pushing on. Adaptive cruise control can be a bit weird, but its also brilliant changing up/down the gears, even to a standstill. Launch control on it's own is probably worth it.
I use it probably 80% in paddle (manual) mode, and I love it. The DSG farts are hilarious too - a good tip, if you are in 3rd gear at 32mph, push foot to the floor, so it changes down to 2nd, and release it back up in about a second - you get hilarious farts.