I don't know about an opening or title screen, but as far as legit introductory sequences go, the first bits of The Last of Us and Xenoblade Chronicles were pretty intense when they set the stage. But something tells me you're not talking about sequences you play through