What I'd love to do is be able to import a sequence from editorial, including non-vfx shots, so that I can ask RV to rebuild the sequence with all the latest versions of shots so that I can see everything in context, immediately, without having to revert to a NLE like FCP or Avid. What I've found is that editorial rooms are supportive of giving me the information I need, even if it means a little more work for them, as long as they know exactly how I'm expecting it.
Here's how I imagine making it work (this example is Avid, but could work for FCP with minor tweaks): they export a flattened reference quicktime of a sequence. They then also export FilmScribe data (XML for FCP) for the same sequence for all relevant video tracks. The VFX shots have been already marked in the Avid by the editorial crew, in a way that the parser could read. The parser would then create a Shotgun friendly import-ready CSV file (or else just bring it in directly via the API), and how there's a playlist that related directly to that version of the sequence.
A future path of development might be tools to compare sequences to flag new work frame ranges, particularly if they're longer than the scan. Essentially I'm suggesting we include the assistant editors into the Shotgun workflow; they'll love us for it!
Personally, I see a tool like this as a huge advantage for Shotgun's integration with RV.
Is anybody already doing something like this?