The automatic filtering seems to work pretty well. Though I can’t say I tried typing a bunch of trash sites into it to find out. 🙂
I’d say it works well enough that it tends to get in the way. A lot of sites are now being served up securely (https instead of http), which is a good thing for security. But the filtering can’t “see” into secure pages so it just blocks them all unless you specifically allow them.
We’ve also used the free version of OpenDNS, which you set up on your router to filter for the whole house before it even gets to your computers.