I can't talk for the manual but it works great on the DSG. It slows you down then brings you to a complete halt in traffic etc and then starts up again when the car in front moves off.
If you have the stop/start enabled, then it does stop the engine (depending on its mood, battery charge etc) and you need to tell it to start the engine and go again by a quick dab of the accelerator or by pressing the cruise control on/off button.
Even if you have the start/stop turned off, then it seems to put a hold on after a few seconds of being at a halt and you need to press accelerator or on/off button to go again. I guess this is a safety feature - if the halt is only 2-3 seconds it continues to drive for you, but anymore than that it needs confirmation to start again.
Overall it is spooky how well it works, which accompanied with the parking assist which works very well also means it is so little effort to drive these days. Of course, when you get a twisty country road you just turn them off and press the loud pedal yourself.
