I have used the GUI version of ExifTool on Mac for some years, satisfactorily. It does do batch mode. Once the EXIF data is edited in the DNG/RAW files, then the editing program (LR for me) reads that info upon importing the files. So it doesn't "work with Lightroom" as such, same I'm sure for Aperture, as it's independent of the subsequent processing.