Most people who read reports shouldn't be in the workspace at all. Publish an app instead: a packaged, read-only view of the workspace's content that you update when the content is ready.
Create app (or Update app once it exists) opens the app settings. An app has one or more audiences. For each audience you choose which reports it can see and who belongs to it, so leadership can get the executive summary while the sales managers also get the detailed regional report. A person in two audiences sees the content of both.
Changes in the workspace don't reach app users until you update the app. Row-level security still applies to app users. Add groups to audiences rather than individuals, for the same reason as in workspace roles.
Two audiences, each with its own reports and its own group.