Akismet has always been good for me for WordPress and I see there's a Drupal plugin for it too. It's not free, but I think it's reasonably priced for how well it functions and the headaches it saves me with no frustration for commenting users.