Vincent can join as a non-playable right before the climactic fight with Sephiroth in Shinra Mansion during/after which Sephiroth chucks some materia at Cloud.