Not to drudge up old hate, but...
They released a DLC a little while back called "Awakened", which was definitely more horror-ish than the main game. While it wasn't as classic as the first game, it definitely felt better than 3 itself. It was pretty good, but just goes to show what a damn...