I'm surprised at this and some of your other responses. It makes me believe you've never managed anything at scale, but then why have such a strong opinion about DNS for infra?

> I believe that a solution where you provision a text file with an updated ip address or /etc/hosts file is inherently simpler

So simple that it doesn't scale beyond a few machines nor outside your org.