The Silent Hill series owes a lot of its success to its music, so that's definitely up there.
A more recent one for me was Shadow of the Colossus, how each giant seemingly had a separate piece of music accompanying it. It was just so epic and exciting, but also very reflective and lonely when...