This information is published on the world wide web but I find myself looking it up all the time. So for my own convenience:
To list all site collections in the tenant that have the site collection app catalog enabled, use the URL:
https://<tenant-app-catalog-URL>/Lists/SiteCollectionAppCatalogs/AllItems.aspx
Or with PowerShell:
$appCatalog = Get-PnPTenantAppCatalogUrl
Connect-PnPOnline -Url $appCatalog -Credentials DevAdmin
$items = Get-PnPListItem -List "Site Collection App Catalogs"
$count = 1
foreach($item in $items){
Write-host $count "-" $item.FieldValues.Item("SiteCollectionUrl")
$count = $count + 1
}