I agree that something like this is needed. The existing Templates category is not clearly aligned with the terminology of the Help:Templates page, and there's no central place for finding Templates By Project or Templates By Purpose. With all due respect to Ales and other stalwart Data Doctors Project, the definitions of DB Errors are not a substitute for good Help pages on templates.
I think the best way to address the need would be to create a two or three high-level subcategories in Category:Templates, something like "Templates By Type" (to include subcategories like Project Boxes, Stickers, and Research Boxes), "Templates By Project," and "Templates By Special Purpose" (to include mostly individual templates, all or most of which will also be in other categories, but also a few subcategories for groups of related templates that members often look for, such as "Ancestry Link Templates," "Roll of Honor Templates.")
I propose doing this with Categories because it is far easier to keep categories up to date (when new templates ate created and old ones are revised) than it is to keep various Help and Project pages up to date and properly coordinated.