On my vrs diesels dsg paddles, the right one is marked with the word "off" what does it turn off?.

Pull right paddle up and hold for a few seconds and it goes back into auto from manual

Or if you are in D, went into manual by tapping the paddles you will return into D after holding throttle steady for about 6 seconds, same as holding the "+" for 2 seconds and you are back in D.