Comment Moderation Using Drupal

I see from Jenny Levine's comment here, that ALA Connect was afflicted (at least momentarily) with comment spam. It's a common affliction.

On most of the sites I support, I now pretty much have to moderate all comments. Even on sites where users have to set up accounts like LibSite.org, I still get spam.

While most of the sites are personal, it's the community or institutional sites where things get interesting/scary.

I'm currently working on a project, for example, where four different units of an large academic department are going to run their own blogs. This is precisely the kind of environment where comment spam can be a huge problem -- especially because the people running the thing from day to day are average (albeit web-savvy) staff members.

I'm just working on this at the moment, but my solution(s) is something along the lines of karenS' Comment Manager. Basically, it's to give a list of all the unpublished comments for the posts that the current logged-in user has written. From there, using Views Bulk Operations, they can either publish or delete the comments.

At the moment I'm trying to figure out whether I need Comment Manager at all, or whether I could get away with just putting the thing together using Views.

I don't really think this is a solution for ALA Connect but it's something I'm working on at the moment.

Update: I'm also looking at Show unpublished comments.