Opening the book…
The resource group is the unit of delete, of RBAC, and of cost rollup. A group holding "all the databases" cannot be safely deleted, granted, or costed for any one system.
One group per system per environment (myapp-prod-rg). If two resources die together, they live together; if not, separate groups.