Yes, that could be quite demanding. You could perhaps have rules set values to your ‘team’ field based on the assignee. This rule could be scaled using a Bundle, available on Enterprise.
However, you mentioned tags - I would not use these since they are not supported in Dashboards and reporting.