I hope people aren't having to use DBCC CHECKCONSTRAINTS all that often 😉

DBCC CHECKIDENT is one that comes to mind that I have seen become part of standardized processes although it probably should not have made it that far. It has many valid ad hoc uses, especially in production support and unit testing scenarios.