Pervasive Monitoring Is an Attack:
You're right, a threat is potential damage, these things are done damage.
But it does. If you need a product generally you would just go out and buy it. Ads are psychologically manipulating you to buy things you don’t need and spend your limited time on this Earth doing things that aren’t beneficial to you. It wasn’t too bad when it was just billboards and TV slots but now it’s you vs the algorithms on a personal level.
1. Targeted ads requires enormous machineries of surveillance and file-keeping. Having too much information in closely related form is akin to having too much uranium in close proximity; it causes problems all of its own almost just by merely existing.
2. Ads in general, even the beneficial ones are, by definition, distracting from whatever content we were trying to read. See: São Paulo’s “Cidade Limpa”.
Now what I'm not seeing is exactly which company's DNS is avoiding what credible harm that people here believe is potentially likely to result from using Google DNS.
As far as Google (or any company, really) internally is concerned, the fact that they are merely "using" the data for themselves (to show you ads, or whatever) is not itself a harm to you. (And maybe worth mentioning, they have used a lot of information to make life a lot better for everyone, like location for traffic data.) The harm would be if they used it to (say) discriminate against you in advertising goods/services, or to harass you, or if they did not secure it properly and your data leaked, etc. None of these are things I'm aware of happening inside Google, but if you know of evidence of this happening, I would love to know.
As far as Google is concerned externally, the only threat you seem to have hinted at here is that you believe they are likely to sell your data to other parties who are then likely to abuse them (such as by harassing you directly, or sharing/exposing your data online to others who might harm you). I have seen no evidence that this has been the case with Google (or Facebook) either -- which should make sense given that you believe user data is their most important asset -- but again, if you have any, by all means do share.
Given the above, combined with the facts that (a) so many people here seem to be disregarding the actual privacy policy, and (b) for most people Google probably already has more information to screw you with than your third-party DNS provider ever will, I'm led to believe there isn't really anything to be gained by avoiding Google DNS. But to each their own...