A release of Shantae Advance is looking less and less likely. Maybe Namco will pick it up if they like the sales of Sigma Star Saga, though. Unfortunately, I just don't see that game becoming a bit hit so far...
Propellar Arena and TFLO are big ones for me, but the biggest was Star Fox 2 for the SNES. Used the Super FX 2 chip (like that buggy game, FX Trax), I remember being so hyped up with the pictures and news that leaked, then it just went dead quiet. I was confused, then found out that it was canned so sales of Star Fox 64 weren't diluted. (Excellent planning there...) SF64 was pretty much a logical "more of the same" step for the most part (Landmaster, sub, lock-on and a few other things excluded.) Star Fox 2 was more of a "Let's see where we can take this" game that tried new things, without losing the core of the series.
I've played a 95% (just a few glitches left) version on an emulator before, and it's just interesting to see where they pushed it. Areas are all-range (instead of on-rails) and they exist in real-time, with you having to defend Corneria while you push forward into the galaxy (wasting too long in an area means Corneria is open to attack). Six Arwing pilots manning three different types of Arwings (all with a secondary mode, the original model has a neat new mech-style walker ability), the two-player combat the original was missing... the game even has Star Wolf in it.
The only bad thing about it is that you can blow through the game in about 20 minutes on the lower difficulties if you know what you're doing, and for many people, life ends at "Normal." (The difficulty levels include changes in the frequency of events in this one, it's not just a damage tweak.) But overall, it's definitely a more interesting game, even though it wasn't as "safe" a sequel as Star Fox 64 was. (SF64 doubly-irritated me because it also rewrote the history established in the SNES games and promo materials previously, but that's another matter.)