I recommend setting the update check interval to one week and prepare for it by identifying potential issues beforehand.
Pamac has an option to download updates on an automated basis.
This is not the same as auto update and there is nothing that makes downloading the updates beforehand a problem.
You can find various creative solutions to auto update Arch based distributions.
Unless you are very sure - you should avoid such solutions for the reasons mentioned above.