It has its moments but falls apart when Picard enters the Nexus.
I think more so when Picard exits the Nexus. When he appeared back in reality.
He could have "arrived" on the planet prior to Soren aboard the bird of prey, disabled/destroyed the missile at his leisure. This also would have (unbeknownst to Picard) saved Kirk's life.
Arrived aboard the Enterprise as Soren beamed over from the observatory, had a security team escort Soren to sickbay, then the brig.
Arrived back prior to the time of the fire that killed his brother and nephew, communicated to preventing their deaths and
prevented the Romulan attack upon the observatory saving the life's there and
prevented the destruction of that star (and the observatory) and
captured Soren too.
having Picard walk into Ten-Forward and arrest Soran would have made a boring end to the movie. It's "rule of drama" people. Why didn't the Borg in FC travel back in time while in the Delta Quadrant and THEN try to assimilate Earth when there'd be no advanced opposition?
And yet somehow, fans forgive FC for that, yet they endlessly harp on GEN for doing the same thing.