In my opinion, not to do it automatically. One needs to generate a new mirrorlist if/when there are some issues with those already specified in the list (like low download speed, being out-of-order etc).
If you have a working list, I would just use that.
No, what @pebcak meant was that we have reflector-simple shipped by default, it is a script that was created by Manuel.
If you open the welcome app, you will see a button called “update mirrors”, this will open a GUI version of that script and whenever you have an issue with your mirror, just click on that button and your mirrors will be updated in an instant.
Updating your mirrors and updating your mirrorlist are two different steps when maintaining your system. What @sradjoker said is correct, it was just already implied that once you update your mirrorlist via reflector, then in addition you also are encouraged to update your database with either sudo pacman -Syyu or yay -Syyu (both do the same thing), which is just a good practice to do after updating your mirrorlist so your system refreshed.
That’s always the problem with a newbie: implying things can, and sometimes does, lead to misunderstandings - I speak from experience
Anyway, your comment clears it all up for me.
Circling back to my OP, I’ll follow @pebcak’s advice, not do the update automatically but do it manually when needed, thereby using the button on the Welcome app as per @pebcak’s and @Bryanpwo’s advice, followed by an update of the database as you mentioned.
Seemed pretty straight forward enough, just added US to the country comment and enabled the systemd timer; looks like it updates every Monday. I’ll keep an eye on it and check from time to time if things are running smoothly, but if it’s one less thing I end up having to do (normally I update mirrorlist once a month) and it works without any issues, I’ll probably stick with this auto mirror option.