I recommend The Machinist with Christian Bale.
It's not really "oh shit" scary.
It's more like a psychological thriller.