It's my only console for now (PS3 busted a while ago).
IMO it looks much better than goldeneye. Probably the best non-nintendo game for it actually. It's not missing much either, surprisingly.
Nintendo Wii Version Edit:
The Nintendo Wii version was also made by Treyarch, and has most of the features of its PS3/360/PC counterparts. There are, however a few omissions due to the limitations of the Wii console itself. They are:
Mission #9, "Crash Site" has been shortened. The player can only steer the boat in the first part of the mission. The rest is unchanged.
Mission #15, Redemption has been shortened. Instead of engaging enemies from the chopper, the chopper simply drops Mason and Hudson off. The rest is unchanged.
Dead Ops Arcade and the Zombie map "Five" are not featured in the Wii version.
The Flamethrower weapon attachment is missing in Multiplayer.
The Valkyrie Rockets, Chopper Gunner, and Gunship killstreaks are all missing due to RAM limitations.
Theater Mode is missing due to RAM limitations.
Ground War is missing, on account of the Wii only being able to handle Black Ops Online with 10 players at the most...regular games are 5 vs 5, not 6 vs 6 like other consoles.
Reticule Customization, Clan Tags, Customizable Playercards, and Emblems are all missing due to the large amount of RAM it would use up.
As usual with Call of Duty games made for the Wii, killcams and final killcams are both missing due to RAM limitations.
Private Matches are not completely customizable. They are about on par with Modern Warfare 2 private match customization.
The Camera Spike equipment is missing in Wii version.
That's quite a decent amount of stuff missing. Enough to affect the gameplay IMHO.