Doom sync auto-update remote URL

### I confirm that...

- [X] I have searched the [issue tracker](https://github.com/doomemacs/doomemacs/issues), [documentation](https://docs.doomemacs.org), [FAQ](https://docs.doomemacs.org/-/faq), [Discourse](https://discourse.doomemacs.org), and [Google](https://google.com), in case this issue has already been reported/resolved.

- [X] I have read "[How to Debug Issues](https://doomemacs.org/d/how2debug)", and will use it to provide as much information about this issue as possible.

- [X] The issue can be reproduced on the **latest** available commit of Doom.

- [X] The issue can be reproduced on a stable release of Emacs, such as 27 or 28. *(Doom does not support development builds like 29+ or any version ending in .50 or .9x)*

### Expected behavior

There should be a flag like `--auto-update-packages` for the sync and upgrade commands, which automatically updates packages if the remote URL or specified branch changes, but not if there are local changes.
This is a pretty common and as I see it rather uncontroversial situation, so one could consider making this the default and adding a `--ask` flag instead.

### Current behavior

When I (or you) change the remote URL of a package, I always have to confirm that manually on upgrade, which gets tiresome.
But I also do not want to blindly accept every prompt when scripting.

### Steps to reproduce

See above

### System Information

---