I don't have specifics but almost any dialogue Kingdom Hearts 1 or 2, Final Fantasy X, Resident Evil 4, Metal Gear Solid(the entire main franchise), Mass Effect 1... Just stating spoken dialogue.
Pretty much almost any AAA title from like 1988 to the present has great moments in them. Hell, even Madden had hilarious lines from about 1996-2005ish about play calling and actions and such. Anything from sports games to role-playing can have awesome dialogue.
If I had to pick a top franchise, it would be the Metal Gear Solid series. The dialogue and voice acting in that game gave me shivers from the awesomeness.