I always recommend Zombies Ate My Neighbors, Monster Party, and the SNES Clock Tower.
If you have a gamecube, also Eternal Darkness.
And if you like the Visual novel type stuff, check out Famicom Detective Club 2. You'll have to get the translation patch for it though. it's an effective little horror mystery.