Categorically, yes.
We had a very similar scenario except with Snowplow (I think - this was many years ago) that used to cost silly money per month.
Replace most of it with GCP BQ Schedule Queries.
A few years we hired a "data" team, they came in and prompt introduced the cluster fire that was DBT. Costs exploded, data was a mess. The few bits of data that we owned, we ring fenced and just kept chugging along on GCP BQ Schedule Queries.
KISS.
Speak more on this, if you don't mind. I've worked some DBT migration projects before, and agree the manual management of everything was fairly time consuming. We used prefect for job management but DBT never struck me as fully baked (like most tech, I assume it has matured some since my time with it)