inherently games aren't really scarey co-op because part of being scared is being alone and overwhelmed.
Maybe there's a weird exception.
Left 4 Dead 2, and Dead Space 3, Re6 (scarier than 5, but still lol) isn't really scary, but probably the most scary co-op I've played... which isn't saying much.