I run two sites that are just Discourse with customisations.
If you know what you are doing you can customize them a lot to achieve more or less anything.
There are loads of open source Theme Components and plugins that can help you.
The only tricky bit is that if you have very specific requirements and your need to build something very bespoke the front end framework can take time to learn and it’s harder to source developers for (even though it’s very good indeed).
Standard installs are very stable and very easy to maintain so go for it!