In some situations like in a small shop, having hundreds of sp_ procs for the DBA to have at their fingertips makes sense. things like sp_foreignkeys or sp_missingindexes, that select data that is relevant to a developing DBA makes sense. That is what this massive collection of procedures are.

The design pattern is that the procedures only report information, and provide a helpful script to save time, but never actually change the data.