The games that:
Moved me: MM (Kafei and Anju), TWW (Final Battle), TP (Zelda's sacrifice)
Saddened me: LA (Koholint Isle disappeared), MM (Final Hour), TP (Midna's sacrifice)
Made me jump off the couch and do a victory dance: ALttP (beating it the first time), TAoL (After 999 (not kidding) deaths on Death Mountain and Valley ALONE)
Made me happy: OoT (Beating such a classic Zelda game)
Other: Made me want to play again: OoT (nuff said).