The discourse software was sleek enough, speedy enough etc; but it was too far a disconnect from how forums of yore worked. Discourse is much better suited for QnA over Discussions where each comment has equal merit; there was also an emphasis on 'personality' with older forum technology which promoted some kitsch graphics design and made people cultivate a persona (which became a reason to put more effort into replies to things).
I'm not sure if I can correctly articulate what I mean, but, just be aware: Here may be dragons.
I rejected NodeBB because MongoDB is no longer developed under a free license. I'll list some other forum software I have considered in case you find it useful: Fossil Forums (https://fossil-scm.org/home/doc/trunk/www/forum.wiki), nimforum (https://github.com/nim-lang/nimforum), Talkyard (https://github.com/debiki/talkyard), Misago (https://github.com/rafalp/Misago), FlaskBB (https://github.com/flaskbb/flaskbb). All of these have less momentum behind them than Flarum. Most are lightweight. I found it very appropriate that nimforum's name is inconsistently capitalized. :-) I am still kind of amazed that Fossil has integrated a forum and a chatroom. During my research I also found an interesting fork of SMF: https://github.com/elkarte/Elkarte.
The Flarum community seems much more friendly, DIY and open. Having to use PHP in 2023 is a little depressing, but it would presumably integrate more easily into other PHP projects like Wordpress.
I was hoping to use NodeBB for the pure js stack but it's missing some important features and the front end is greybearded out of using a modern framework because of "speed"[1]. You can use Postgres instead of Mongo, by the way:
> NodeBB Forum Software is powered by Node.js and supports either Redis, MongoDB, or a PostgreSQL database
[1]: https://community.nodebb.org/topic/14371/nodebb-reactjs/3?_=...
Honestly, if I was going to pay for a forum, I'd probably go with (self-hosted) XenForo from the start. It has the most polished user experience of any forum software I have seen. I understand people sell custom mobile apps for it, too, though I haven't really looked.
I thought using NodeBB with PostgreSQL was not recommended for production. Looks like I was wrong. Thanks for telling me.
Conforums seems defunct