The answer is Suikoden :P

Final Fantasy 7: One winged angel( best one is the one in FF7 AC)
Aeris theme
Intro
Kingdom Hearts 1 & 2: Fantasia alla marcha
March Caprice
Simple and clean orchestrated
Roxas theme

I havent played xenogears, seems great by the way u talk about it.

Oh, FF X had awesome music too, well, almost every FF has.

Never played the game but I love this song

Have played the game, love the song

There are alot of great ones. Like The World Ends With You, Legend of Dragoon, FFVIII, FFIX, etc. It's a pretty large and pretty awesome list.

I'm surprised not more people posted Secret of Mana. I think it might be because a lot of posters are too young to have played the game as most of what people are posting are from the PS1-PS2 era.

Also, Chrono Trigger has great music:

The final battle of FFVI:

Finally, a pretty heavy song for a Nintendo game

mother 3, super mario rpg, or ffx

Yikes... I hadn't ever heard that before. The original is fantastic though.

Anyhow, I'll cast another vote for FFIV if not just because it's often overlooked but also because it's simply fantastic. One of my favourites (among several) from the game:

Live:

DS Version

My Favourite all time RPG tracks:

Dungeon Explorer

Phantasy Star online
Ys Book 1& II (turbo-cd)
Panzer Dragoon Saga
Lunar 2 Eternal Blue (sega saturn version)
Infinite Undiscovery
Grandia (sega saturn version)
Secret of Mana
Chrono Trigger
Tengai Makyou IV (aka far east of eden)

Panzer Dragoon Saga:

Dungeon Explorer (really EARLY ATLUS game)!!