I would have no qualms about new DSG boxes. 25 years ago the early ones were a little troublesome when they were introduced, but nowadays they are as reliable and durable as manual gearboxes.
That's not to say they last forever, but the same applies to manuals. They will need maintenance over their lives just like manuals, but should last as long as the engine and other major car components. And of course there will be no more clutch costs.
So your decision comes down to whether you prefer the transmission to take care of itself, or you actually like to be involved in gear changing.
Personally I fail to see the attraction of repeatedly tramping on a pedal and waving a metal pole sticking out of the floor just to make the car perform its basic function of travelling from A to B, when everything else about the car such as windows, seat position, mirror position, temperature etc. is automated. The crudity of a manual gear change amongst the sophistication of all the other control functions is jarring to my way of thinking.