Not sure about the RS4 but in the RS6 if you were in comfort mode and pulled the gearstick to switch to Sport mode the gear changes and engine mapping went into Dynamic but the suspension, sport diff etc remained in comfort. I think the exhaust valves opened in Sport too.