http://www.youtube.com/watch?v=oku0yZ84RuI (Zelda theme, Donkey Konga)
Fantastic! So, dramatic, so.... awesome!
Memorable, and beautifully played, featuring horns, keyboard, strings, guitar, cowbell and others- it gives it a Latin/jazz feel.
A major one I forgot-
http://www.youtube.com/watch?v=EV77owpNVcg (Yoshmitshu, Tekken 2)
A beautiful and very haunting piece, which starts slowly, builds tension and a techno beat kicks in, with a big key change, resulting in an excellent and spooky piece of art.