SoulCalibur II always did that for me. That opening montage was epic back in the day.
Resistance 3 has the killer opening in the modern era, to me. The way it uses that old-fashioned animation with great art to illustrate how the spread of the Chimera got to this point really psyched me up.
backlogger.tumblr.com - The Backlogger, where I wade through an ever-expanding backlog of video games