I'm kind of on the fence about my country's censorship (The UK, that is). As far as I know, it's only child porn that is actively censored, and whilst I don't mind it being censored due to what it is, it does spark the question "Where will it stop?"
I think the real question to ask is "what is the use of the censorship?" For example, when it comes to child pornography, how many children are actually saved by blocking child pornography sites? The blocking itself, obviously, does nothing to help the problem.
And what about distribution of child porn? Does the censorship make that more difficult? Clearly it would be quite impossible to make studies on this, but I'd hazard a guess that the censorship lists do nothing to stop the distribution either, because the distribution can be easily done through much more secure (and private) channels, once there is a contact between the customer and the provider. This could be one of the potential uses of the blocking; it might make it more difficult for CP distributors to find customers, if their public sites were blocked. But of course this isn't true at the moment either, because it is very easy to circumvent the censorship and because the leaked blocklists are a "nice way" to find these illegal sites in the first place.
On the contrary, I think these blocklists are downright harmful, because they lull people into a false sense of security and into thinking that something is actually being done about the problem. Instead of making secret blocklists and coming up with even more useless ways to filter and block "harmful content", I think the authorities should concentrate more on actually closing the sites and finding the people responsible for them and the material on them, because in the end that is the only way you can get these sites out of the Internet and help the children that are being exploited.