I don't know if it is possible to add Finder Keywords somewhere? So I presume you want to duplicate the same Finder comment in the IPTC/XMP Caption/Description and Keywords/Subject, right? And then manually fine-tune them, if necessary?
The following command does that (and also mirrors the info in MacOS MDItemDescription and MDItemKeywords):
exiftool -m -P -overwrite_original_in_place '-IPTC:Caption-Abstract<MacOS:MDItemFinderComment' '-XMP-dc:Description<MacOS:MDItemFinderComment' '-IPTC:Keywords<MacOS:MDItemFinderComment' '-XMP-dc:Subject<MacOS:MDItemFinderComment' .
After that command there is the following metadata which Preview.app and Photos.app show:
[MacOS] MDItemFinderComment : Finder comment
[MacOS] MDItemDescription : Finder comment
[MacOS] MDItemKeywords : Finder comment
[IPTC] Keywords : Finder comment
[IPTC] Caption-Abstract : Finder comment
[XMP-dc] Description : Finder comment
[XMP-dc] Subject : Finder comment
The same info is duplicated in IPTC, XMP and MacOS tags. IPTC is the old standard and XMP the new but currently both are used because you never know what application happens to support or prefer one or the other.
> Probably also worth adding "(insert filename / folder name here)" at the end of the command
I prefer to use just the dot: The dot '.' at the end of the long command means 'this folder'. Or alternatively, omit that dot '.' at the end, and instead type the exact name of the file you want to process. Or type just the start of the filename, and then press Tab to use autocomplete and maybe insert '*' to the end, and hit Return to process all files that start with the same letters. Or add '-ext jpg' switch to the command to process only files that have .jpg suffix. Or use wildcard '*.jpg'. That was a rather clumsy instruction but I guess you get the idea.