99% of the time it is just automatic and part of the update. Usually it's only an issue if you are updating from a specific older version of something or have made a particular customization that breaks with the update.

Like others, I've got at least one system running Arch for 10+ years and I've only had to manually do something a handful of times. Usually it's just that I have to update the keyring first before the rest of the update.