I enabled the service yesterday on my account, just to see what it's like, and I have to report that it's not too bad. The categories are the standard ones that anyone familiar with a corporate web proxy filter product will see, so give it a rest on the Government Conspiracy rhetoric around categorisation of content. There is a custom filter set you can specify too.
If you really want to look at pr0n, you can set a time when the filter is inactive, so just configure it for when little Johnnie has gone to bed. And if you hit a site outside that time that you don't want blocked, you can even put an exception in there to allow it, no great hard work required.
I really don't see what the big fuss is about as long as there is the ability to turn it off, which the account holder has the ability to do. And before you start complaining about not being the account holder, quit your bitching as you're obviously not paying for the connection you're trying to surf on!
There will always be those that don't want the filter, and there will always be 101 ways around it. This is meant as a simple tool to help those that want filtering on their broadband connection to implement it without them having to install lots of software or build their own filter servers.