I think this should be fairly easy to do:
- Get all activities
- Create a matrix of activities and tags by looping over each activity in your course/category/system and then marking each tag.
- Output the matrix object to a renderer.
Best solution should be a report_ plug-in. However I'm fairly certain you could get creative with SQL and Configurable reports.