Productions - Recovered Clips - Changed Metadata

I've been using Productions (currently on Premiere 24.3.0) for the past year on multiple feature docs and smaller projects.

The biggest problem I've faced is improper linking between clips in sequences and their sources in other projects. For example, a clip inside an edit sequence in a "Sequences" project won't "reveal in project" back to the source clip in a "Media" project in the same Production, even if it was cut into the sequence from that project/clip. I've experienced what many others have: "Recovered" clips being generated in the sequence project, Premiere unable to locate the source for a clip, etc. I've used all the known solutions to some degree of success [Reassociate Source Clips; dragging clips back into their home folder, Consolidate Duplicates] but ultimately this is a recurring issue.

I've experienced this in BOTH projects that were converted to Productions, and projects that originated as Productions, following all best practices for creating a Production and ingesting media, etc. 

I think I've come to understand at least one part of the root of the problem: differing metadate between the clip in the sequence project and the clip in the media project. I don't pretend to be an experience on metadata, but I believe this is metadata local to Premiere, not embedded in the file (which makes sense because the duplicates are linking to the same source at the Finder/Explorer level). The most common culprit in my experience is Premiere's Transcription feature. When comparing an original clip in a Media project, and its duplicate in the Recovered Clips folder in the Sequences project, often the only difference I can find is that one clip has been transcribed and the other hasn't. Let's say I'm an Assistant Editor, and I've got all the media ingested. I've given the Editor the green light to start cutting, but in the meantime I'm still logging footage in the background in the Media project. The editor cuts in a clip that hasn't been transcribed. I then have Premiere transcribe it in the Media project. Now Premiere sees these as 2 different clips, and can't reconcile them: it creates a "Recovered" clip in the Sequences project. Multiply this across a feature documentary and now I have a huge mess on my hands.

This is a major bug-- even if this is intended behavior, it is a huge workflow hangup, and reduces the effectiveness of two of the main benefits of Productions: the ability to segregate differents parts of the production into different projects, and the ability for multiple peopel to work in the same production simultaneously. I've been recommending Productions to Editors and AEs as the way to go for feature documentaries, but I've now had to include this caveat: a central part of the workflow is broken.

I would love for Adobe to address this. This could be a more powerful "Consolidate Duplicates" (options like "Favor transcribed clip" or "overwrite metadata fields", ability to select which clip becomes the "true" clip, etc.), a more powerful "Reassociate" command that provides some options for how to handle the clip to prevent future recurrences, or some kind of warning when you are altering metadata on a clip that is already in sequences in other projects ("Update clip in other projects?"), though this last concept points to a seaparate bug: "Video Usage" and "Audio Usage" are broken between projects in Productions.