In a meta sense, too. They weren't allowed to film much in the actual streets of St. Petersburg (for obvious reasons), so most of the chase was done on a studio lot, with them making it so realistic that, reportedly, Russian audiences were outraged that the filmmakers callously destroyed so much of the city (and the statue in particular).
Bond escaping from the chemical weapons plant on a motorcycle, which he then rode off a cliff and caught up with a plane.
At the beginning when Bond jumps from the top of the dam. The free-fall and eventual landing scene that follows is several seconds, maybe even up to a minute, of a single sound of whooshed air. When this movie first came out, that was the moment when people knew this Bond film would revive the series.
Natalya, after a Forceful Kiss from the Big Bad, responds with a thoroughly hard slap. The fact it made him stumble backward was awesome in its own right.
If only for the acting, General Ouromov's first meeting with Defense Minister Dimitri Mishkin. Ouromov's expression when he learns that Natalya survived his treachery at Severnaya is glorious.
Bond's flippant bemusement in the face of an interrogation and possible execution:
James Bond: What, no small talk? No ... chit-chat? That's the trouble with the world these days, nobody takes the time to perform a really sinister interrogation. It's a lost art.
Followed by Bond shooting his way out of the military headquarters.
Bill Tanner: Seems your hunch was right, 007. It's too bad the Evil Queen of Numbers wouldn't let you play it. (winces as Bond clears his throat in a "By the way" manner) M: You were saying? Bill Tanner: No, no, I was just... just um... M: Good. Because if I want sarcasm, Mr Tanner, I'll talk to my children, thank you very much.
The conversation between M and Bond after he points out the mistakes of her analysts.
M: You don't like me, Bond. You don't like my methods. You think I'm an accountant, a bean counter more interested in my numbers than your instincts. Bond: The thought had occurred to me. M: Good, because I think you're a sexist, misogynist dinosaur. A relic of the Cold War, whose boyish charms, though wasted on me, obviously appealed to that young woman I sent out to evaluate you. Bond: Point taken. M: If you think for one moment I don't have the balls to send a man out to die, your instincts are dead wrong. I have no compunction about sending you to your death. But, I won't do it on a whim. Even with your cavalier attitude towards life.
Xenia Onatopp's preferred method of assassination. Out with a Bang indeed! Onatopp's sauna fight with Bond also qualifies - the idea of Bond nearly being hoisted by his own petard is great, and it actually follows through in some ways in what Goldeneye is trying to do with it's female characters; It's the only time since Bond's fight with Bambi and Thumper of Diamonds Are Forever that Bond has been rendered vulnerable by a Bond Girl. To Bond's credit, the scene and his encounters with Onatopp are made more awesome by the fact that Bond is still able to get out of her death-grip twice. Even when the second time was assisted. To her credit, Bond only escapes both times arguably by cheating. He's unable to stop her by himself physically and she essentially laughs off and finds pleasure in his attempts to do so, which is pretty impressive for a Bond Girl.
Also awesome for Famke Janssen in only her second high-profile role - she did a number of her own stunts, including driving Onatopp's Ferrari. She also threw herself into the role so much so that she managed to break a rib during the filming of the spa fight and actively managed to intimidate Pierce Brosnan after winding stuntmen and accidentally hurting her co-star during her love scene aboard the yacht.
Also, the final fight between Bond and Janus. Competing for the title of best fight in the series with the fight between Bond and Red Grant in From Russia with Love. Word of God says the similarity was intentional.
Natalya, not Bond, is the one who ultimately foils Janus' scheme by reprogramming the satellite to drop out of orbit. Made even sweeter by Boris taunting smugly that she can't stop GoldenEye from firing: "She works on the guidance system." Yes, and a lot of good being able to fire the thing will do you when it's burning up over the Atlantic, won't it?
When Boris exclaims that Natalya changed the access codes, it's her "You're goddamm right I did" look that sells it.
Natalya also gets a few other awesome moments, such as when - on the run after barely escaping Severnaya with her life - she walks into a computer store with nothing but sheer audacity and bluffs her way to net access by posing as a buyer from a university.
Natalya beating the crap out of Boris when she meets him in Janus's control room. It took two mooks simply to restrain her. And judging from the cut to Janus's smirk, even he thought it was pretty awesome.
And her having the presence of mind while terrified by the office being shot up to fake an Air Vent Escape.
The title sequence, both because it was a new take on the classic Bond opening that set the scene for those in later films, and the powerful imagery with the Communist iconography being destroyed.
And the multiplayer was done not only at the last minute but it was done without telling anyone else on the development team.
Going even further, the multiplayer mode was considered near-revolutionary by both fans and critics, cementing the game's status as a killer app for the N64.
The Complex, a level that didn't even appear in the game or movie, is still considered to be one of the best multiplayer stages ever.
For a slightly more obvious Moment of Awesome, see no further than the wonderful applications of Tank Goodness.
The grenade launcher in Surface and the remote mines in Facility are very fun to play with, especially in multiplayer.
At the end of the trainyard mission, Bond steps onto Alec's train, and two guards appear on either side of him. He guns down the one on the left, whips around to kill the one on the right, and then pauses, turns, and adjusts his tie right as the doors slide shut. Classic Bond.
Activating the floating mine cheat on the bunker level with unlimited ammo can make for some of the best multiplayer fun ever.
Activate invincibility cheat on silo level and set off an explosion by time-out. A huge fireball will appear behind Bond and follow him wherever he goes. This will kill every enemy he's passing by. The level is unwinnable now but so what?