There are some differences. In Auto mode (I'm most familiar with the Mavic 3 Pro but this is essentially the same across the board with the exception of variable aperture comments) the drone adjusts EV on it's own. The M3Pro manual does not...
However....it's important to know when Auto doesn't work well and be able to control the Pro settings which differ from wide to tele lenses on some drones....
From the DJI fly app when using the drone you go in to Settings and sign out from your account. I can't describe the exact steps but as far as I know that's the important thing. A call to DJI or a visit to their web site and chatting with them...
Most folks use one (pro) or the other (auto) on occasion although some just use Auto :). There are times when, as you say, the lighting is dynamic and you are changing from very bright to darker areas and leaving it in Pro would not work at...