I know PPro is able to read and create xmp metadata. But I don't think it will read the metadata from Camera Raw or Lightroom to pick up edits in either of those applications. At least I can't figure out how to do it.

If what you pretend is doing the same as with theRed files: to read the source settings and or affect the rawDatas into the editor or affect them from the developperItself and see the changes in your timeline, But doing that from an image sequence and instead of Red Cine XIt would be camera raw or lightroom or capture one,I'm afraid it's not possible yet, and specially if you are notIn raw config as the moment you do a tiff, how would youAffect the file? So it has to be raw workflow.Red provide a separate metadata file, completly indepedantFrom the image file and this is why you can load thoseMetadatas into the camera itself or into a software thatCan read them, like PP.When you do an edit into the raw dev, only the metadataFile is updated.(manually)This: the separation between the metadata file and theRecorded one is something I never stop to point theImportance in the workflow. Red understands it.

But if for ex, you had apply a filter in LR, and you wantThe editor to recognized the filter in question and eventuallyRevert to the stage pevious the filter, forget it.Same with cropping etc...

If you want to manipulate still images in a motionEnvironement, and have your metadatas conected,You need to be in After Effect or Nuke, means softwaresMotion specialized and capable to handle 32bits.So you manipulate your stills in those and not in LR or ACR.

With PS you can do a little bit more with the layersAnd alpha channels and some editors will work moreOr less well but not really we can talk about integrationAt the level you are talking about in what editors are concernedAnd there is not an all-in-one solution that covers bothTerritories, still+motion+edit+compositing.Sure it will come in the future but for now we're not there yet.