i've been driving my city vtec for 3 years already...
and i'm currently driving a GTI...
love the CVT smooth acceleration.. quick revs...

but problem is CVT really fragile.. and those lower end cars with CVT cannot mod at all... like what someone said cannot tahan the high hp/torque
i've never driven a more expensive car with CVT like A4 etc

but after driving my new 4 weeks old GTI
i would definetly go for DSG over CVT

i have only 1 problem with DSG...
if u are cruising on 6th gear... and u want power and u full throttle u will have some lag time... due to the gears need to downshift 2-3 gears.. hence will take some time for the DSG to downshift from 6 to 3-4
as for manual tranny all about user preference.. since TS only asked about CVT and DSG i would suggest stick to the topic

for malaysia (KL) roads i would sure go for auto better... go where also jam >.<

the gear 1 and 2 jerking is because using ron 95?

DSG FTW!! 
If the transmission gets confused in heavy traffic, just switch to manual mode. All you have to do is find the sweet spot at the throttle for every gear change for buttery smooth, sporty, eye-watering, orgasmic inducing shifting.    bit carried away that last bit, but you get the idea. 

I'm assuming that every car with DSG has a manual override option....right?