Here's a neat project by disbala, who is retexturing The Legend of Zelda: Twilight Princess to look like Skyward Sword—the newer Zelda game in the franchise, which features visuals which aren't as realistic.
The project has been going on for a couple of months now, with the video teaser appearing earlier this month. No word on when this will be finished, but still, it's cool to look at.
Also...this fan reception, which the creator highlights on the previously linked forum post, is amusing:
"I have to say it doesn´t work for me."
"I gotta say I'm not feeling this at all."
"Doesn't fit the dark gritty feel of the game. I hate it."
"Now, all we need to do is make SS with TP grapichs :3"
"It looks like a map in TF2."
"Pretty cool, but doesn't look very good. I prefer the original."