Sniper Elite has one very cool 'bullet cam' feature. unfortunately the rest of the game ain't so great. But if there's a demo, or you can pick it up for a couple of euro's it will keep you amused for an hour or two.
Or if reality is your bag, then how about Armed Assault. Making your own missions is as simple as falling of a log, but there are plenty of good quality missions to be found over at Armaholic.
As far as movies are concerned, the one that comes to my mind is Enemy at the Gate. It's not the best film ever made, and is purely fictitious, but again, will fill in a couple of hours or so