Stop farking about Potsy! You're not going to change anyway, you've only just got this one.
Automatics are great. If I like them they can't be bad at all.
The modern ones are just as economical, if not more so, as their manual counterparts apart from maybe in stop/start town centre traffic where you may lose some mpg. I have been driving auto's on and off since 2003. Started with my huge 03 plate Merc Sprinter luton van which had the Sprintshift gearbox. This was great for the first 90k but once the clutch started playing up it was never right again for more than 5-10k at a time. Real shame because it was beautiful to drive when it was working right and as a mechanised manual box with dry clutch was just as fuel efficient as a manual.
After that came my yr 2000 4ltr Jeep Cherokee auto. Not very hi-tech but brutal and effective. Again a pleasure to drive even with all the off-road modifications done to the vehicle. The best bit was that it was a blast when off-road too, always in the right gear and gave the ultimate in control. Coming from diesel Defenders I had worried about it, but it was in so many ways the better vehicle! (slightly off-topic. I had the chance to drive one of the Landrover 50th anniversary V8 auto Defenders and I am ashamed to say the transmission behaviour wasn't a patch on the Jeep, a bit like the engine and gearbox just weren't in tune).
Had an 05 plate Passat Tdi auto up until very recently. The last of the B5.5s and this was also a very nice and very quick car. Supposed to be 130hp officially but always felt like more to me and the traditional TC gearbox was perfectly matched to the engine. Very economical, would regularly return 50mpg without trying and even doing rush hour commutes around the M60 and out to Skelmersdale (lots of nose to tail stop/starting etc) I would often jump in and see the trip computer showing a tank average over 45mpg.
Just replaced the Passat a few months ago and went diesel auto again. Now Mrs Skol drives an Audi A4 Tdi with 190hp and the CVT auto box. They don't do this box in the current range but it is bl**dy amazing. Goes the instant the accelerator is pressed but is smooth, calm, quiet and always just right. Also holds back on the engine nicely when going down hill. Touch wood it doesn't ever go wrong though.......
I guess if you are staying with VW then you will get a DSG box. Haven't owned one but test drove a few because we were going to get a newer Passat and they seemed to do the job just as well as any other good automatic so can't really fault them either.
In a nutshell, I don't think you will regret going auto.