Instead of using tenant level app catalog, let’s use site collection level app catalog to manage lot’s of custom apps only for specific site.
https://docs.microsoft.com/en-us/sharepoint/dev/general-development/site-collection-app-catalog
Powershell script to create site collection level app catalog
$siteURL = “https://xxx.sharepoint.com/sites/Test”
Connect-SPOService -Url https://xxx-admin.sharepoint.com -Credential abc@xxx.com
Add-SPOSiteCollectionAppCatalog -Site $siteURL
#Remove-SPOSiteCollectionAppCatalog -Site $siteURL
#https://xxx.sharepoint.com/sites/[SiteCollectionName]/AppCatalog/Forms/AllItems.aspx
To list all site collections in the tenant that have the site collection app catalog enabled, use the URL https://xxx.sharepoint.com/sites/appcatalog/Lists/SiteCollectionAppCatalogs/AllItems.aspx.