I've got a DSG box on the Audi - which gives me a number of automatic modes, as well as the option of clutchless manual (via the flappy paddles on the steering wheel).
Most days it ambles along in "D" or "S" depending on my mood - but the fully manual option is good fun on backroads.
I paid a few buttons (OK about £60) for a 'Hold' button option - when this is engaged there is no creep at all when stationary - very useful in stop/start traffic as you don't need to keep your foot on the brake all the time when stopped.
I agree that I won't voluntarily go back to a 'normal' stickshft box - provided I can afford this type of enhanced automatic.