and
>DNS isn't appropriate for filtering porn or ads
So, if you're trying to filter porn out, dns doesn't work because of sites like reddit.
For kids, a whitelist of approved domains should work. If you don't think Reddit should be on it, you don't add Reddit. No brainer.
The problem with DNS is mobile devices; your custom DNS runs only in your own intranet, not whatever devices connect to.
Undoubtedly there are hacks for that, but they are mucky compared to the pure DNS solution, which can be perpetrated entirely externally to devices.
Do you do all of the your movement with a car? No, it doesn't work well for very short or very long distances. That doesn't mean it doesn't work.
Hostname based blocking can never be accurate.
Fine-grained filtering of content within Google domains doesn't seem tractable in any way shape or form.
Reddit isn't a porn site in the sense that if you go to "reddit.com", you're automatically shown porn. It's a diverse site that has adult content areas.
Reddit has profile settings like:
[ ] NSFW content hide images for NSFW/18+ content (Don't show thumbnails or media previews for anything labeled NSFW)
[ ] I am over eighteen years old and willing to view adult content (required to view some subreddits)
Needless to say, these are implicitly off or a visitor to the site who does not have an account.
Still, Reddit will not prevent visitors from seeing "adult content" in a more general sense:being exposed to adult discussions that can touch on any sort of topic from any angle.
If we're talking about protecting kids, I think a whitelist of allowed sites will be better than a blacklist, which is intractable.