What's the difference between Standard and Dynamic Modes? When should I use them? give examples please

TLDR; use standard mode. If that doesn't work, then try dynamic mode.

Thanks @stalbert

the main difference is dynamic mode tries to simulate working with the record in the UI - so the order in which you set fields is relevant.