Either are good options for all sorts of reasons
But I bought a manual, and would buy a manual again.
My thoughts: I don't live in a city so feel I don't need an auto. 2 friends have auto's 1 with a GTI PP the other with a A250 AMG. They both like it but neither enjoy driving in the same way I do, they like nice cars but don't seem to get the thrill of driving like me, as I want to drive to Spain, french Alps, Nordschleife and don't mind the keep fit gearbox at all. While they like the laziness of it and don't often use the paddles.
I also don't think the DSG is light or efficient compared to the PDK in the Porsche, which improves on its manual alternative in performance and economy. So not only are you adding weight with the DSG, but also worse mpg and worse Co2. The next gen will hopefully be on par with the 8 speed in the BMW which is a great gearbox I think, but the DSG we have in the Mk7 seems imo a little long in the tooth.