I’m still working my way through some of the more idiosyncratic aspects of the current Automator development environment but it’s starting to look pretty good so far.
This is what MetaSync looks like if you implement it as Automator actions.

The first action returns the items that are currently selected in the “TIFF” catalog. The second action is where the guts of MetaSync take place - the image item names are mapped as specified and then a lookup is performed in the “Raw” catalog. If it finds a match, the annotations for the raw file are copied to the finished TIFF catalog. The “Copy Annotations” action currently returns a list of the images from the source catalog that matched. This means the final action can label them so I know what’s been converted.
This is an example of my basic image import workflow. It’ll get added to fairly soon but it seems to work at the moment.

I should have the actions polished up and ready for release in a few days.