That sounds an awful lot like Itory Village in Enix's "Illusion of Gaia"
http://www.youtube.com/watch?v=erKDJjWqjvs
"In the Earthen Womb" is my favorite from that game though:
http://www.youtube.com/watch?v=4jPfPdW-5LM
Honorable mention:
http://www.youtube.com/watch?v=zbA98pYh244
FWIW, these are straight from the SNES VGM score...
not orchestrated.
Edit: That reminds me. The intro to Enix's "Wonder Project J2" on N64 goes through a wide range of emotions.
http://www.youtube.com/jevansturner#p/u/27/_WuzOFzXD6s
And, err, unemotional responses (the whole game is about raising a robot girl so that she becomes more human). They recap the lonely scientist's first creation, Pino (yes, like Pinocchio; from Wonder Project J on SNES), sacrificing himself to save the world and then go on to his sudden death.