I remember playing this mostly at my friend's house around the time the game was released. It was an even better sequel to Agent Under Fire.
I didn't get much time with the single player, but it was quite a step up from the previous 007 game. The first one since Goldeneye to truly wow me.
The multiplayer was also really good. I wished this game was around the time where online console gaming wasn't terrible. Oh well split-screen was tolerable back then.