I mostly use Redgate and home grown solutions for DDL audits. Fortunately, I work mostly with OLAP databases and DML is not as big an issue. That auditing is handled in ETL processes.