In the emotional vein of the movies discussed above:
Nightcrawler is very very good and very unusual. Prisoners is very good though more ordinary in its plot and characters and I found that I forgot about it after a while and didn't realize I'd seen it until I was rewatching it... It's not especially tense but it's well written. Drive is an incredible noir thriller. Goodfellas is another one that has unforgettable moments that will force you to just clench your fists, even if in the end the story left me feeling a bit empty. I should probably throw out American History X too, which is a different sort of movie but still has that feeling of "oh my God did that just happen?"