Well speaking about hardware that never made it past the prototype stages for one reason or another:
NatAmi by the NatAmi Team
and the list could go on forever...
But the natami is still being worked on, progress is still regularly posted on the official website with photographic evidence? That's not vapourware.