It is not entirely clear to me from reading TFA, but infer from its description and other comments here that Photo only works with RAW input files. Is this correct? Or can I use it on JPEGs?

Yes, it works with JPEG, HEIF, PNG, TIFF, AF, PSD, and several other still image formats.