Doom Classic Co-op
The Matrix has 6 horror games on file for the Super Nintendo, released between 1994–1996. 1 of them support multiplayer, including 2 with co-op. They're ranked below by legacy score, so the games that shaped the genre on the SNES come first, with lesser-known picks further down.
Horror games build dread through atmosphere, limited resources and enemies you would rather avoid than fight. Survival horror in particular makes every bullet count.
Typical commitment: an evening or two (roughly 1–6 hours to see it through). Tip: Conserve ammunition and healing items, explore carefully, and play with the lights off for the full effect.