Another example that may not fit entirely into what is generally known as RPG's is Warlords Battlecry. Probably the most amazing soundtrack ever found in an RTS:
http://www.youtube.com/watch?v=kiqswLdVrxI
http://www.youtube.com/watch?v=0MeSY9X2 ... re=related
http://www.youtube.com/watch?v=kiqswLdVrxI
http://www.youtube.com/watch?v=0MeSY9X2 ... re=related