Best for: anything but real-time chat, really.

Maybe the best way to think of Discourse is as an anti-Discord. It's everything Discord isn't: asynchronous, open source, and self-hostable.

Then why is it the highest rated "Discord alternative"?