After spending days reading and understanding the cons and pros of what I see, the three leading forum software for my needs: Flarum, NodeBB and Discourse, I've decided to install the beta of Flarum (I do understand what it means).
Flarum lacks many of the features that the other forum software solutions have, but it is based on the most recent technologies (e.g. discourse has both desktop theme and mobile theme, instead of one single responsive theme), and it looks better than the others, very slick modern UX.
I've chosen Flarum because I believe in the technology behind it, and I know I will benefit from it in the long run. I do have some things that I want to be changed, but we have a great communiy that can make it happen. I am a developer myself (C#/.Net) and I don't have problem managing my server (on AWS) for the meantime.
The community is great and I'm sure that we'll get to have some great new features in the near future.
This is my way to support the project and show my appreciation. I know that for production it probably be better to go with either NodeBB of Discourse, but I believe than not too long from now, flarum will be the best forum software among the three. I can understand by just looking on the Github, the UX and by reading the moderator comments that Flarum is in the hands of great developers that really understand how to build an amazing modern forum software.
I am currently in the middle of making my server ready and I'm sure to share my issues if I found them.
I'll make backup images of the server before upgrading, and follow the upcoming upgrade and upgrade my server accordingly. It's easy to backup the server on AWS in just a few clicks. I also intend to use RDS for the database.
Thanks.