Example on Meta just yesterday: I saw a topic with some random words with mispellings/random letters. I was about to flag it when the topic disappeared and a banner at the top said that Akismet hid it. When you reload the page, it 404s.
I’d say that it’s certainly quite reliable, although as with any of these kinds of software, there will be some false positives or some that it may miss out on.