First game I played when we got a PS2 when I was wee, MoH: Frontline. Just the music throughout the "Arnhem Knights" level, overlapped with the ruined town and some history knowledge, the level just feels terribly sad and desperate.
http://www.youtube.com/watch?v=4OdtAEiHU9s