As well as being a developer I have a number of bought-in packages to DBA and they all use dumb database designs despite only being available with SQL Server database engine!

This causes slower and more convoluted processing and there are some fine examples of bad design but we have to live with it. It's on these that I have used triggers to monitor e.g. where are blank data fields being added to the table or what is deleting records...

For our own in-house software there's no need - the stored procedures can handle auditing as there is no direct updating.