I highly recommend the Akismet module for Drupal. It's made comment moderation so much easier for us at Wise Bread. I tried the spam module first too, but Akismet is way better. Best-in-class, by far.

Cheers!