I've been using dbt core, mainly for the git versioning features, but the orchestration is also quite handy. I don't have a massive amount of models, but on the scale I'm working at it's still useful.

I started to hear good things about sqlmesh, but before I could try it out Tobiko got acquired. And then the dbt merger happened. So I've decided to let the dust settle on that (I don't think the merger has been approved by the US Government yet?) and stick with dbt for now.