I actually really enjoy the game, but I wasn't expecting a straight remake of the N64 game (and that would have been the wrong way to go).
Sure, the game is a lot more linear than the N64 version, but there's still multiple ways to go through each room and generally at least a couple different paths. You can use stealth or go in guns blazing. The AI's fantastic and the storytelling and voice acting is top-notch. I really feel more like James Bond than playing the N64 version.
I think the score by David Arnold and Kevin Kinney is wonderful... lots of cool moments like the Nightclub level. I think the MP music is a little disappointing but there's certainly music (and some of it is really good like when you become Bond or Alec in "Heroes" mode or the score in "Black Box"). IGN specifically turned off the music for the demo videos they did for some reason.
I haven't played the split-screen mode yet, but the online is wonderful for the Wii. Easy to find a match and while the frame rate dips sometimes I haven't ran into lag problems. The maps all seem pretty well designed in MP.
Pointer controls are quite good (I used the experienced 3 setting). If you've never played a Wii shooter and think you point at the screen to shoot instead of using the controller like a 3-D mouse you may want to use the classic controller or GC controller.
The "Black Box" game mode in MP is absolutely fantastic and a ton of fun. Really feels Bondian.
The gist of the mode is that MI6 has captured an enemy briefcase and is trying to hack into it to get the data, while the other team (Janus, the Russians or Zukovsky's goons) has to destroy the briefcase. If you're on the MI6 team, you want to carry the briefcase and hold it (which fills a meter on-screen that shows progress "hacking" the briefcase). While you're carrying the briefcase you can only use a pistol and your movement is slower. You can drop the briefcase at any time by pressing A, but the hacking stops at that point.
The Janus team wants to shoot/grenade/melee the briefcase to damage it (there is another meter showing the "health" of the briefcase on screen). They also want to kill the MI6 team member holding the case so that the hacking stops. Once that happens the briefcase falls to the ground So you end up with a group of guys all huddled around the briefcase on the ground shooting the daylights out of it. The briefcase also moves around a bit depending on where it's shot, so you can slowly shoot the briefcase into a corner or into a tunnel. It's really quick paced and frantic and well-balanced.
It is a disappointment that there isn't a "Classic" mode with N64-style weapons loadouts dropping on the map and no regenerating health in MP.
I can't overstate the fact that it's fun and a good game even if it's not anything groundbreaking like the N64 Goldeneye. I know everyone here is going to be pre-disposed to hate it, but Eurocom put a lot of effort into it instead of just doing a cheap cash-in like Rogue Agent.