I don't think that the DSG would be
more enjoyable to someone who enjoys the greatest level of control. There is something just right about doing that - that it was all your skill that that gets you the perfect, smooth and fast gear shift.
However, that doesn't mean that manual transmissions are better. I quite believe that the DSG is better in performance aspects - speed of shifting, etc.; and ease of use certainly.
At the moment I drive automatic only - I'd learn manual shifting (well, I already can, just no practice lately) properly if I could, and there was a reason to (none of our family cars are manual), but there isn't. Chances are, in all likelihood, that the wife won't drive manual either. So why bother? My car will serve me, and I don't want to mould my life and circumstances around that of what transmission is in my car (ie. getting to learn it, getting others to learn it).
So, that said, the DSG is an excellent compromise for me, and the best way to go at the moment. Good performance with the ease of use of an automatic. One unmentioned bonus is that the fuel economy is equal to that of the manual (at least on Golf GTI).
I also wish that Audi would make it available throughout the lineup, though; especially with the A4 2.0TDI. Hey, the Golf 2.0TDI has it?