This is probably the only console FPS that I can actually abide playing. The layout of the N64 controller leads to an intuitive, yet complicated control system. Also, and correct me if i'm mistaken, but this game was the very first to have a variable zoom sniper-rifle. It follows the story of the film very well, whilst still being a great single-player game. Impressive stuff. Still very much the best Bond game out there (The less said about 007: Agent Under Fire the better). If you have an N64, and don't have this game, you are clearly insane. The multiplayer is also good, although Unreal Tournament is...just better, really. Hey, split screen is a downer, Proxy mines are fun.
Summary: Best FPS on any console ever. Great single-player and multi-player.
Graphics: 9 (It's on N64)
Sound: 10 (silencers, one-liners)
Gameplay: 10 (shoot the catch with your watch laser)