1. Final Fantasy VIIStatus: Completed, 2005
ShenZhen Nanjing Technology's NES version of Final Fantasy VII is a lot like the Large Hadron Collider: the science behind it is so complex, that we literally don't have enough Internet to describe it. Here's the nutshell version. In 2005, a team of Chinese programmers and coders decided to test the limits of 8-bit technology by condensing the entire story of FFVII within the confines of the "SUBOR" system, a ugly little Famicom clone that was little more than a keyboard with a game slot.
But that wasn't even the impressive part. What made headlines around the World Wide Web was that the thing actually worked. Even early claims that the whole thing was some elaborate hoax died quickly after concrete proof was published by the original source, blogger Derrick Sobodash. Okay, so maybe the random battles took forever to finish and a lot of artwork was borrowed from other FF titles. But, it was still the video game equivalent of the Human Genome Project, and it's probably the closest thing we'll ever get towards a remake of FFVII.
Foreign Final Fantasy
Luckily, Square Enix either didn't catch on to the project or didn't care, which was likely because the entire thing was written in Chinese and ported to a device that no gamer owns. Can't read Chinese? There's also an English patch floating elusively around the Web, mostly on torrent sites and peer-to-peer networks.