Silent Hill is a game that I think is actually creepy mostly because of the atmosphere, but I think Zelda did it very well with MM.There was almost nothing gory about it but I think in the end the point of the game was to help people to accept that the moon was going to fall.