In response to Caterkiller:
Causing Mechbeth to crash into the munitions factory (or whatever that was) on Planet Macbeth was the high point in Star Fox 64 for the Rumble Pak, in which case I believe that Star Fox 64 will be made available at about the same time a possible Classic Controller Rumble Pak is released. That clip's got to be there for something, right?
The N64 did have a lot of good multiplayer memories, and there do need to be more games released there. However my heart is still on Super NES games; most of the major franchises have had their best games there (Super Mario RPG: Legend Of The Seven Stars, The Legend Of Zelda: A Link To The Past, Super Metroid, Donkey Kong Country, Kirby: Super Star, etc.).
In response to BlackNMild:
Gunstar Heroes is a Genesis platform shooter (run and gun!) by Treasure. Like in the vein of Contra, but cartoony, hectic, and extremely challenging. The characters are wacky and named after colours (the main characters are Red and Blue), and some of the bosses are really neat. It's just chaotic and crazy. The GBA game Gunstar Super Heroes is very similar, but the Genesis one is the original.