AppFresh isn't bad, although it does occasionally throw up some spurious results for apps that have already have the latest update. In SL, uncheck the "Check for available Apple updates" otherwise it takes forever.
The two that I evaluated were AppFresh and MacUpdate. To me...MacUpdate did a better job of automatically updated my software when an update was issued.