Hi @james-mke
We can fetch the matching asset using Query Builder as mentioned below (example where Product A asset is tagged with product id "product-1331" , Product B is tagged with product id "product-1221" & both assets are under different root path). you can change OR & AND condition between tags based on your requirement.
Query Builder Result :

Query :
property=cq:tags
property.1_value=test:product-1331
property.2_value=test:product-1221
property.or=true
group.1_path=/content/dam/test
group.2_path=/content/dam/images
group.p.or=true
Hope this helps!