for SNES games you can always use SNES9x Wii Edition :P

Super Mario RPG, SNES Starfox, LoZ: Majora's Mask, Chrono Trigger, Dragon Warrior 1 - whatever, SNES Pilotwings, N64 Pilotwings, Rush 2 Extreme Racing, Mario Paint (Wiimote as mouse), NES Duck Hunt (modified with a calibration screen so you can get 1 to 1 pointing with the Wiimote), any other game that used the NES Zapper or the SNES Superscope, Faxanadu, and Crystalis

And actually, you don't even need to install any wad or ISO if you use the Twilight Hack.
There's SNES9x that has been released to run on the homebrew channel and it works pretty darn close to perfectly. I use it for just about any of my SNES games that aren't out on VC yet (or may never be released for it)
The N64 emulator is pretty meh right now, but it'll likely be up to par by the end of the year.

Amazingly, i dont think its been mentioned yet, Goldeneye 007 (N64)

ssb and ?

Contra.

Japan only games from the Famicom Wars and Fire Emblem series.

Megaman X 1-4

Super Smash Bros.

Super Mario Kart

GameBoy / Color Games (Specifically, Wario Land 1-3, Pokemon Red/Blue, and Mario Land 2.)