So, I've been dicking around with Project64 and the ability to load high-resolution texture packs for games. There's a guy out there who has pretty much single-handedly retextured Ocarina of Time in cel-shaded style, and the results are stunning:

And now some comparison shots!
spoiler (click to show/hide)
It's like playing a completely different game. Wow.
There are also high-resolution packs out as well, which don't change the art style of the game so drastically. I've been using a high-resolution pack for Majora's Mask, and the subtlety of new clean textures as opposed to blurry-as-hell 1996 technology is fantastic.