Akismet has failed us, too many times. We have observed many sites with it installed which simply become flooded with spam.
Self hosters should use Discourse AI with one of the many free models if budget is a concern. Gemini Flash 2.0 free tier does the trick reasonably.