Feature Request: Auto-scale ResourceGroup or increase object limit to prevent KNV2009

### Checklist

- [x] I did not find a related open enhancement request.
- [x] I understand that enhancement requests filed in the GitHub repository are by default low priority.
- [x] If this request is time-sensitive, I have submitted a corresponding issue with [GCP support](https://cloud.google.com/support-hub).

### Describe the feature

Description: Users are encountering the error KNV2009 - source repository contains too many resource objects when the number of resources in a single ResourceGroup exceeds the current limit. This blocks the ability to scale, add new users, or sync additional resources. Currently, users must rely on manual workarounds to fix this, which introduces unnecessary risk to production environments and is not a sustainable long-term solution.

Feature request: We would like a solution that allows ResourceGroup to either:
- Auto-scale: Dynamically handle larger numbers of resources without manual intervention (e.g., auto-sharding).
- Increase Limits: significantly raise the maximum number of resource objects that can be inventoried by a single ResourceGroup.

### Importance

_No response_