Might be Alan Wake 2. I've actually been saving myself the DLCs for a rainy day, and I'm probably due to play through The Final Draft again this October followed by them.
I guess it's not a full fledged horror though in the sense that the story and the mystery is perhaps the biggest focus. It's plenty scary at times and the nursing home level is just survival horror perfection, but it's not one of those games that solely focuses on scaring you shitless all the time if that's what you want.
Also you kinda gotta play Alan Wake 1 first, and ideally Control too and the AWE DLC. And those aren't as scary.