It is very charming and enjoyable but there's little to do in the endgame, and it kinda starts to get tedious even in midgame tbh. Everything else is pretty much perfect though, good performance, UI, modding support, lots of freedom and creativity when it comes to designing settlements... Just don't expect it to be too complex or demanding at any point.

I love Timberborn. I haven't played the two games you've mentioned, so I can't commemt on how they compare, but it is a great game.

There's some lets-plays on youtube that'll give you a better feel for it than the trailers.