Why aren't going with the old and reliable infrastructure solution - multiple DNS servers?
Setting up an additional DNS server in a different region and putting them together in a Multi-DNS-system.
https://petri.com/best-practices-for-dns-forwarding/
I just found a Step-by-step tutorial for Windows 2003 (it was updated in 2021), but that should still explain how to proceed on newer versions.
https://learn.microsoft.com/en-us/troubleshoot/windows-server/networking/configure-secondary-name-server