I love that mission because I carried a turret through like the whole thing.
just peek it around corners. Unstoppable.
I think Xenogears had a big one but that might be a weird confluence of images.
any way here is a baby unit:
Resident Evil 2 (remake) has an incline cable car sequence.