What you’re describing is not a man-in-the-middle proxy, but a simple DNS block. That’s a very crude approach to blocking ads and notoriously doesn’t work for YouTube and Google ads because they’re served from the same domain.
I run a pihole myself but there’s still a huge difference between browsing with pihole only and pihole+ublock. It’s certainly not the answer to the Manifest V3 shenanigans.