In the environments I support, auditing is required by regulation. I have rudimentary tracking enabled via trigger on a subset of sensitive fields. Additionally, I use the default trace for troubleshooting.
Audit's the only way to explain what happened, when, and who did it. I try to include it in every new system I design. And yes, there's pushback about its importance and priority when it comes to development, but I'm in a business area that demands it.