The thing people often forget, is that people didn't buy an NES or a Wii, they bought Super Mario Bros. or Wii Sports; the NES and Wii just happened to be attached to those games. They didn't sell well because they were bundled with the system, the systems sold well because those games in particular were bundled. It couldn't have been done with any other game. Those are the quintessential system sellers. Wii Sports even more so because it's range was even wider. In fact, I think Kinect Adventures has a similar influence as Wii Sports, and sold it's system in a similar manner, albeit on a much smaller scale than Wii Sports did.
Tetris would be third, it almost did the same thing as these other two, but had a couple of games to help it, most notably Pokémon Red/Blue. Super Mario 64 and Halo as you mentioned were also great system sellers. It's difficult to rank them I think. People were willing to wait for this game and the N64 with it because it was so awe-inspiring. Arguably, the N64 had the best launch line-up even with only two games just because this game was one of them. It also managed to singlehandedly sell the N64 for years, boosting other 'lesser' software's sales up when we waited for more worthwhile games. Halo on the other hand made the XBox, without it, there would be no more XBox. Halo 3 only sold so well because there was a Halo 1, which laid the ground-work and thus the heavy duty. That makes Halo 1 a bigger system seller in my opinion even if it's sales are lower. I think it brought a lot of PC gamers to consoles because Halo finally made the FPS genre good on consoles. I think those are basically a tie, but with personal bias I'll rank Super Mario 64 above Halo:
1. Wii Sports
2. Super Mario Bros.
3. Tetris
4. Super Mario 64
5. Halo







