Currently Online 
One of the most unfortunate changes in the 7th generation, for me, was single player campaigns taking a backseat to multiplayer. This game, however, stands as a shining example of what an FPS campaign should be, and it's greatness comes down to two key elements.
Empowerment
As the saying goes "every man wants to be James Bond." (What about female gamers you ask? Well, nothing wrong with a little transgender fantasy, I often like to pretend I am Bayonetta) His slick, super-spy professionalism is infectiously cool, and the 7th gen Goldeneye remake captures this beautifully.
Sneaking around, efficiently dispatching guards really makes you feel like a badass super spy. The sense of satisfaction is quickly taking out those two guys talking idly about how they're bored and wish they could see some action is immense. A lot of this comes down to the sound design; the exhilatring sting when you're spotted, the tense heartbeat that follows, the the musical exhalation of relief when the alarm isn't sounded, and the dramatic note when you put a bullet in the brain of a patrolling guard without alerting his comrades. You feel like you're really outsmarting these guys, an assassin fliting between shadows, raining death without ever revealling himself.
Of course, all-out firefights aren't entirely avoidable, surprisingly these don't diminish the sense of empowerment, but rather add another dimension to it. The punchy sounds of bullets thudding into your enemies and their equally punchy hit animations are far more satisfying than in the vast majority of shooters, where enemies go down with less aplomb. The Wiimote and PS Move controls on the Wii and PS3 versions further enhance this sense of immersion, of being Bond. You still feel like a badass, just one that blows his enemies away with the gusto of an 80s/90s action movie star. (Think Bruce Willis in Die Hard or, indeed, Pierce Brosnan in the Goldeneye movie)
The destructible environments help too; it easier to feel powerful when your bullet crumble concrete, and the kick is divine when you bring a building scaffold crashing down on your enemies.
You don't just feel like a generic grunt when you play this game; you feel like James Bond, and it feels good.
Tightness
As console RAM capacities and CPU grunt have increased, battlegrounds in FPS campaign have grown larger and more complex. Potentially, this is a good thing. But in many cases, this has led to sprawling, messy environments, which lack the design elegance of smaller, more tightly crafted arenas, and often compromise their gameplay design in order to seem more naturalistic. Now, I'm not arguing for corridor shooters here. What I'm arguing for are the kinds of battlegrounds the Goldeneye remake has.
There's no wasted space or untidiness here. Everything is placed like clockwork, from the enemy patrols to the myraid of destructible environments, most of which can be used strategically to take out or expose enemies behind cover. Levels are tightly and efficiently designed, with multiple ways of approaching situations. The stealth sequences aren't the overly scripted rubbish Call of Duty passes of as stealth; you're aren't led through them by the hand, you have to analyze and outsmart the enemy by yourself, which is much more satisfying.
Ironically, the game benefits from its roots on the Wii, with its limited 91MB of RAM. This forced the developers to come up with smaller level designs where every detail could be given an extra amount of care. The result are levels that are remarkable in their compact elegance.
Sadly, the fact that the game shares its name with one of the most influential first person shooters of all time seems to have robbed it of its thunder. I firmly believe, though, that its single player component is on the top tier of the 7th generation's FPS games.
