Saddest:
Gears of War: Dom finding his wife + later his death
Last of Us opening scene
Pretty much the entire last quarter of Shadow of the Colossus
Best:
Knights of the Old Republic: Revan reveal
MGS Psycho Mantis
Halo CE first playthrough just after release