I started a new branch the other day called "template_usage" that adds a couple of things for working with templates:
From the Edit Template screen, I added two new options: "Namespace Usage" and "Instance Usage" (see the screenshots).
Instance Usage shows you a list of all assets that are currently using the template.
Namespace Usage shows you all assets that include the template's namespace in their definition, and related info such as the hoverHelp for that field, etc.. In other words, this is a list of where the asset *could potentially* be used.
Across the top of the page are two drop-downs:
The big thing missing from this is that it only considers assets. Colin mentioned that he has some code that lets you query *everything* in wg that uses definition() - e.g. not just Assets but also site settings, etc.. That should allow us to extend this RFE to cover pretty much everywhere a template can be used. Perhaps we won't be able to get full coverage, but it will certainly make the process of reviewing and decommissioning a template less error-prone.
The other feature I want to add is a third drop-down which lets you diff the template against any other template in the same namespace. The obvious application of this is for diffing your custom template against the default template (e.g. after an upgrade). The stumbling block here is that there doesn't seem to be a good cpan module for generating diff output to html.
I implemented this on a whim because we were about to do some template changes, so the code is somewhat lacking in direction.. so we might want to throw it away and re-write it with a clearer vision.