here's my favourite. haunting. it gave me chills as a child and still does
the first 20 seconds are sublime. the silence, eeriness. it's such a good thematic representation of that game. and then, classic zelda kicks back in - the music, the town, the characters! except, at the end... there's a hideous aggressive musical cue cutting through it, as it ends on that iconic shot. it's perfect
All Kingdom Hearts games seriously the openigs scenes + the themes. Yeah it's insane brings tears to my eyes....
The KH3 one is gonna be insane with that new theme song damn..... I bet theyll do a cgi opening that shows all events so far + new stuff. It's gonna make me bawl like crazy.
Also KH2 roxas and metal gear solid 2.
Edit: MGSV gets lots of flack but the opening is insane.
Ha was just about to post this^This one is pretty strong too. Though I'm not sure if we're talking about attract modes or opening cinematics.