File organization app that syncs with Finder - including tags

This isn't really a direct mac app question, but more of help finding an app that works well with Mac.

I am looking for a program to help us organize our photos and content for our business.

Currently we use Google Drive and integrate it into Mac Finder so that we can manage those natively on our machines instead of having to access them and download them from a browser every time. This works great. 

Our issue is that we have photos that contain multiple products and we just don't really know what folder to put them in so that we can find all photos of that particular product in one place.
(Ex: if I have a photo that has a keyboard and a deskpad in it and I put it in the deskpad folder, I will never actually see it if I am looking for photos of the keyboard.

Google Drive has the feature allows you to add a "shortcut" of a file to other folders where there is just one master file that shows in many other folders. In theory this is good thing, but it just takes so long to execute one file at a time.

So I thought about using tags on files where we could tag every product that is in a photo and then just search that tag whenever you are looking for photos of a specific product. And if you want a photo with more than one product, you just filter by both tags. This seems to clearly be the solution.

HOWEVER, the tags on google drive and mac finder do not sync. Which means if I had the tags in finder on my side, none of the rest of our team will see them. Its's only local. I need these tags to be available to everyone in our business. It also seems that tags in Google Drive don't sync out to Finder, so that isn't a solution either.

So i need a program that can sync into finder with tags both ways for everyone who has access to the files.

I was hoping Adobe Bridge could do this, since we already have the program, but it doesn't seem like it does.

I just don't to add another program for our team to have to download and have open all the time. That is why i really want it to be able to sync with finder, so all these files are right next to the rest of our files in Google Drive.