My favorite follows the current trend which is Majora's Mask. It throws you right into the action and really has a fun explanation for how the game starts, even if he explanation seems a little shallow. Scarecrow child goes crazy in the woods and becomes possessed demon child who steals your horse, curses you, and brings the moon crashing to Earth. Nice way to start a game, but hey, how much more of a motivation do you need?