Heavy plot - no gore
Cape Fear (1991)
Fire in the Sky
John Carpenter's The Fog

Heavy plot - little gore
Jacob's Ladder
Manhunter
Near Dark