You know what's funny?
Metroid Dread for the Nintendo DS.
It was set to return to its roots, being a sequel to Metroid Fusion. A true shame this never saw the light of day.
That was two years ago. Better late than never, as the saying goes.
Another game that was mentioned in that same topic is
Echo Delta, which was set for release on the N64, but, albeit completed, was canceled at the last minute.
A prototype of the game was sold on eBay in 2006 for $1520, and apparently was dumped, but has yet to appear anywhere...or maybe it's well-hidden, floating somewhere in cyberspace.
Speaking of the N64, two years ago the rights and source code for Dragon Sword were acquired by PIKO, the ones responsible for resurrecting 40 Winks. As far as I know, the game was unfinished and a buggy mess, so it seems they have their work cut out for them, especially if we put into perspective that most of the other games they've secured in the past were completed or near completion. Nevertheless, the game looks cool; it kind of reminds me of Dragon Valor.
Another one for the N64 would be a Pokémon game aptly named, "Pocket Monsters RPG" that was meant for the 64DD peripheral, apparently preceding Stadium. As a fan of the series, it would've been nice if it had seen the light of day given the series just now made the shift to 3D.
Lastly, way before Avengers in 2020, there was another Avengers game that was meant to loosely tie-in with the MCU and was set to feature the Skrull invasion. Apparently the game would've also had a few other elements we've seem spread throughout the MCU movies so far, so I'm guessing they got together and agreed not to blow their load in video game form. I'm of course jesting, the game was canceled due to financial problems, so the rights ended up going to Ubisoft and Avengers: Battle for Earth came out of that, which is crap.
And yeah...