I'm surprised dbt tests is this far down in the comments. This seems like the obvious place to start.

OP (or others) - If you've used dbt tests, I'm curious where it fell short? Tt doesn't cover everything, but it's pretty good in my experience.