Castlevania: SOTN (memorable dialogue (that is to say, so bad it's good), boss and music, perfectly setting the stage for one of the best games ever created)
Metal Gear Solid (the lift scene)
Metal Gear Solid 3 (the HALO jump scene)
Halo 4, Mass Effect & Mass Effect 2 (for the reasons you mentioned)
The worst would be Mass Effect 3, without a shadow of a doubt.
English
-
Yay! The reason I didn't put MGS up there is because it's not the intros to all the games that I find memorable. It's the endings. Seriously, [I]every[/I] MGS game has had an absolutely brilliant ending. But yeah, the HALO jump was awesome.
-
I have to agree with that as well. Even some of the weaker games in the MGS series have amazing endings.