If we expand trailers to commercials, the Majora's Mask ones were really exciting. I'll admit that the 3ds remake trailer made me start losing my mind too, although not sure if that was the trailer or the fact that it was finally going to happen at all!
Breath of the Wild for me, but that's because I didn't start following games on the internet until after Skyward Sword, so no other game trailer appeared with the same build-up of hype and emotional response as Breath of the Wild.
https://www.youtube.com/watch?v=wOJZCWskLXE
I remember seeing this in middle school. Years later, we finally got the game they advertised in the live action portions of this trailer. It came out simultaneously for the gamecube and Wii. Today, it's known as Twilight Princess.