I mulled this over when choosing our newest family run around, ended up with a Ford Mk2 Kuga Powershift.
It has a dual clutch gearbox (very similar to DSG) and is a joy to drive and tow the caravan with.
Gearbox services are every 50,000 miles. I did ours myself last year, cost £140 in Genuine Ford oil + Filter and an hour of my time (plus I know it had been done right).
Deffinitely don't regret buying a dual clutch.
A work mate has a BMW 335D DCT, 160000 miles and still going strong.
Horses for coarses but I won't be going back to a manual.