The fundamentals are fundamental for a reason. Don't go crazy with them, but triggers are great. (especially if you version control all your data definition language code)
i love triggers, started with them, and they are still a good toolset to have if CDC is not an option by the source database we need to pull from