[bother]

"and very quickly you hit the red line as it won't change up!!"

I can't say I've tried it in the Kodiaq as I very rarely use Manual mode, but in the other 5 DSG cars I've owned if you hit the red line it will automatically shift up, in the same way that it will shift down if the revs get too low and it's in danger of stalling.

 

[bother]

Again, not tried it in the Kodiaq yet, but previous DSG cars have had some intelligence when it comes to descending in normal 'D' mode.

Say for example you're going down a hill @ 40mph (arbitrary speed) and the car starts to accelerate, if you press the brake to maintain 40mph the car 'notices' this and then automatically shifts down to provide engine braking to try to resist the acceleration.

There are limits to the engine braking provided and it won't rigidly maintain the speed you were going when you braked, but IMHO it's done made a pretty good fist of it.