seems like too much effort for... what do I get in that scenario?
I may not be the best person to ask since I just buy domains and only use them internally. Like my coredns right now just points at my domain controller because I had Windows server licenses.
It's possible Unbound may have the functionality you're looking for though. I've seen people use it conjuctions with Pihole, I just haven't had a chance to play with it yet.