Dynamic mode kicks in the sports steering (heavier steering feel), exhaust modulator (fake v8 sound), slightly sharper braking response (allegedly - tbc) & obviously the sports gearing selection. Plus I'd assume stiffening any adaptive suspension, if you have any.
Knocking back the gear selector in comfort/auto mode just gives you the sports gearbox. Nothing else.
Cheers, Morgan