The last one was Nightfire, but the one before that was Agent Under Fire which sucked except for the multiplayer.
Everything or nothing is pretty good, kinda plays like splinter cell. I love some of the toys. However, for multiplayer, you need two people unlike others where you could just play against bots or by yourself against yourself. You have to actually beat levels in Co-Op mode before you can play deathmatch mode. Which sucks, because I have no friends

.
Nothing will ever be as good as Goldeneye. I loved the N64 controller layout. I wish I could use it on the GC.
Sorry, looked on gamespot, Rogue Agent was released 11/22. I had no clue.