Kingdom Hearts had a fantastic theme song by Utada Hikraru and great orchestra and piano playing. FF was good too.

Stronghold had great tense music. "The enemy has breached the walls..." after the Scribe says that it really gets exciting. music changes if your overwhelmingly outnumbered to equal numbers.

Brother In Arms had great main music but during gameplay there is no music at all and you feel the full ferocity of war when a tank kills your squad and you can't do nothing about it...

DW4 had a good mix of Chinese and Rock music.

Halo/2 good chorus, battle music etc. just great.

i believe i know more but can't think of any right now.