i was never a Silent Hill player but involving sheet music just seems diabolical.
When we go back in time to puzzle games like Myst and what not there wasn't an immediate chance to get a clue by going online. That is the last time i remember being truly frustrated by a game but these are all great examples for sure.