Interestingly that Quora thread has an article from MakeUseOf that speaks highly of Google DNS. But after Google sold their domain registrar business to SquareSpace (yuck) I’m not sure it matters to web developers.
–> https://www.makeuseof.com/google-dns-vs-cloudflare-dns/
In the Cloudflare vs. Google DNS comparison, both are leading DNS service providers with many valuable features.
If you value your privacy and want to keep one step ahead of the competition, Cloudflare DNS (1.1.1.1) is, in our view, the best option. On the other hand, if you’re facing issues with internet speed and connectivity after connecting to Cloudflare—you might prefer using Google public DNS (8.8.8.8/8.8.4.4).
tldr this is mostly for using DNS servers in your laptop network settings or things like that.