I would like to know if it is possible to see in Marketing Cloud the count of emails that are using each email template. This is really useful, for example, when doing a clean-up of the Business Unit.
You can use the content builder API to fetch this information. When you hit the API, in response you will see the template used by the email.
You can write a SSJS script to store the email information along with the template information.