I also can't pass up Red October. My biggest problem is, being a Navy Airdale, when the Tomcat crashes on deck, it changes into Commander George Duncan's F-9F crashing on the flight deck of the USS Midway, CVB-41, in 1951.
Love the movie but interestingly Russian friends at the State Rocket Centre in Miass, Ural Mountains (Design Centre for SLBM's) reckon Sean Connery portrays one fantastic Submarine Captain! (I worked with these guys on proposed international Space projects a few years ago).