Fix extract_otio_review plugins to accomodate image sequence and media with embedded timecode

[robin-ynput]

Is there an existing issue for this?

• I have searched the existing issues

Current Behavior:

From issue initially reported on ynput/ayon-resolve#15 (review)
It looks like the logic from extract_otio_review plugins requires some tweaking to accommodate image sequence and media with embedded timecode.

A similar work than #897 seems required.
This will impact review products from Resolve, Hiero and Flame.

Expected Behavior:

The extract_otio_review should extract abd generate proper media with handles when input is one of:

• single movie
• image sequence
• single movie with embedded timecode
• image sequence with embedded timecode

Version

1.0.0

What platform you are running on?

Windows

Steps To Reproduce:

1. Generate a timeline with image sequence and/or media with embedded timecode in one of Hiero, Resolve, Flame
2. Try to publish a review product
3. ExtractOtioReview plugin will likely fail with out-of-range issue

Are there any labels you wish to add?

• I have added the relevant labels to the bug report.

Relevant log output:

https://github.com/user-attachments/files/17056322/publish-report-240919-10-57.json

Additional context:

No response