I have been using the Akismet spam filter for the last 4 months and I think it is great.
In my blog, all comments need to be approved by a moderator. Before Akismet, I had to wade through tons of spam everyday. Now, I get 2-3 a week.
If you are a wordpress user, you should definitely check it out.