I have been running Pi-Hole on a raspberry pi at my home for about a year now. I have had pretty good results. I also configured the Pi-Hole's upstream DNS servers to block porn sites so the Pi-Hole itself will then not resolve domain names that are known porn sites. I have been pretty happy with this however on occasion I have found that I have to whitelist certain domains.
I'm wary of making it handle all DNS for the house in case it causes issues for the family. It's just doing one PC for now. I'll play some more