I still remember X-Play going on and on about how good BG&E was and going into a TRU less than 2 months after it came out and it sitting in the clearance bin for $20 CAD. I snagged a GCN copy.Unfortunately it happens sometimes; a game being good doesn't guarantee sales. Case in point: Beyond Good and Evil. Both games were critically acclaimed yet floundered commercially. Such is why marketing is so important. Another more recent example is Titanfall 2; a game with an outstanding campaign that was kind of sent out to die with that release date and lack of marketing.
Wanting to play Metroid Fusion was what made me buy my own handheld for the first time (I previously just borrowed them). I picked up a GBA SP on launch day in March 2003 along with a copy of Fusion and loved it. I didn't hesitate to pick up Zero Mission a year later and proceeded to unlock every ending in the game. It was so good.