Best Level Ever: The Pontchartrain Bridge. Bond hops on a motorcycle and powers his way across the Lake Pontchartrain Causeway, the longest bridge in the US in about 3 minutes flat, and the game does an amazing job of convincing you just how suicidally fast you're going. Over the course of the trip, you've got the chance to power slide under a fuel tanker and ramp over the watery divide to drive againsttraffic. Throw in motorcycle-riding henchmen, the ability to dispatch them with a shotgun, and Jaws driving a rig containing the nanobots that will destroy New Orleans' levies and flood the city, and you've got an amazingly badass level.
Better Than Canon: The game was Brosnan's final time playing James Bond, and ultimately was much more well-received than his final film appearance in Die Another Day, to the point that many fans consider it the true fourth Brosnan Bond film.
Evil Is Sexy: Katya. This is to be expected when she's played by Heidi Klum.
Harsher in Hindsight: One of the missions involves Bond preventing Diavolo from using his nanobots to destroy the levees in New Orleans. Keep in mind that this game came out in 2004, one year before Hurricane Katrina.
Narm / Narm Charm: In the usual spirit of "Bond One-Liner's" you either enjoy a few but one too many bad puns test the average players limits. This game has so many of them you're either groaning every time you hear a new one or laughing at the fact the writers added this amount of bad puns into a single game.
Paranoia Fuel: Using the nano suit after enemies have already engaged you will make cause them to nervously look around for you. Walking while crouched makes your movement silent so you can go anywhere without being seen or heard (until your batteries die, that is).
"I just saw something!"
That One Level: "Escape through wall" in the very first mission has probably resulted in "controller through television", at least the PS2 version, as no clues - visual or otherwise - suggest that the way to accomplish this goal is to return to the location where you started the mission. The training level that follows also qualifies if you happen to hit the PS2 glitch that makes it impossible to shoot the targets after you crouch.