Final Fantasy VII, Final Fantasy VIII and Final Fantasy X, of course.

Oh, and Ico's intro was also quite good. No music, no spoken audio, but incredibly moody. It sets the scene perfectly, and is very well executed. Come to think of it, I don't think it's actually an FMV, but I can't remember - it's been that long since I played the game.