My team has several RED, Sony FX6 and A7SIII cameras (almost identical to the FX3). Most of our cameras use professional container formats such as R3D or MXF. Only the A7SIII/FX3 uses MP4. The Sony MP4 clip timecode cannot be read by FCP so each clip appears to start at 00:00.
The root cause is the MP4 container used by Sony Alpha and many other "consumer grade" cameras does not support timecode in a standardized fashion. During the era when MP4 was designed, consumers did not use timecode.
In 2013 Apple looked ahead, envisioned a looming problem, and wrote Tech Note TN2174, which advised hardware and software developers to either begin using Quicktime timecode structures in future MP4 formats, or else devise something else consistent. Without that, there would be no standardization, and any timecode in MP4 containers would be ad-hoc extensions that would not be universally compatible. It appears they didn't listen to Apple. The manufacturers, developers, and standards organizations did not come up with some equivalent, and that's where we are today.
The Sony MP4 clips actually contain timecode, but it cannot be read by FCP. The best workaround is use the QTChange utility to rewrite timecode to a format FCP can read. This can be batch executed on hundreds of clips and is a one-time workflow step.
In a broader sense this shows the difference between a professional container format such as MXF vs a consumer format like MP4. Our FX6 cameras record lots of useful metadata in the MXF container which facilitates post-mortem evaluation, color matching, etc. The MP4 container does not have that. If you watch consumer-oriented reviews of various cameras, they are typically not aware of workflow issues like this.