if you want ultimate fun and driving involvement, i think you should get a manual
if you want the fastest gear change, relaxation, 90% of the fun, something for the wife who prefers manual, a cool gadget, no worries about missing gear changes or getting lost with 6 gears, then go for DSG
for the driving experience of a hot hatch, you should be driving a manual. for something closer to a fast exec sports hatch, then DSG is great.
if I am 100% honest I do have a slight regret about having DSG when around town as it does have the odd "moment" (well documented elsewhere). but i am happy that the benefits it brings just about outweighs the compromises