I haven't played any of the Fatal Frame games or Ju-On, but both might be reasons for me to dust off my Wii. And with Halloween approach, it seems like the perfect opportunity to get/play those soon. They booth seem interesting.
Though, I'm glad you mentioned Dragon Quest/Warrior as an example. I would have said that if you haven't.
Though bringing up an RPG, that reminds me that the concept of using chance to make the player more cautious and dilligient is something i see a lot in roguelikes with things like traps (to encourage you not to dilly dally and take the shortest route as to have less chance to run into a trap) or how a magical staff or scroll might not always have a consistent effect or may even malfunction on you. So, that makes me curious as to whether or not a game like Phantasmal, a "survival horror roguelike" could actually work or not. I'm hopeful at least.