I dunno...movies don't have lasting effects on me usually. Not in a profoundly sad and direct way.

But 'Apocolypse Now' comes to mind.

As does 'Runaway Train'.