I'm surprised nobody's yet brought up Civ IV, or more specifically Baba Yetu, the theme track which remains the only video game piece to win a Grammy.
However, there are mentions aplenty of the god that is Nobuo Uematsu and the Final Fantasy soundtrack, as well as Yoko Shimomura's Kingdom Hearts. So good.