1. MM
2. OoT
3. ALttP
Especially the first two, those games had all the best in cinematic effects but weren't a gazillion hours long. Now I LOVE SS and I liked the beginning a lot and it helped set the story up, but it felt like a movie more then a game there for a bit. In MM especially you get a short, and very intriguing cut scene, then your thrown right in the action chasing the Skull Kid down.