sorry to hear you are struggling so much. I hate dbt also for similar reasons... but I hear it works wonders for others.
hope you can find something helpful...