The ambush at Aisha's house is a truly vicious shootout. It's just the Boss and Johnny Gat against perhaps a dozen Ronin killers, many armed with machine guns. The Boss' teamwork with Johnny is pure combat pragmatism, as each kills enemies in their respective blindspots, while Johnny duels Jyunichi. It ends with Johnny impaled by a katana, only to slam the enforcer on both sides of the head with his fists, stunning him while the Boss reloads his pistol. Jyunichi barely escapes with his life.
Gat's "get up" sequence with Shogo Akuji at the cemetery.
Specifically, at his girlfriend's funeral, Gat beats the hell out of the Ronin leader's son for giving the order to kill Aisha. He finishes the kid off by emptying a nearby casket and stuffing him inside, proceeding to bury him alive.
Boss gets one by...not saying a damn word, and s/he only drags Shogo to Gat. S/he's a Talkative Loon, both s/he and Gat are in a state of Tranquil Fury because of the seriousness of Shogo's actions, and just leaves the bereaved to do his thing.
Also the one time where we see The Boss give deference to Gat, who normally lets the Boss do all the killing of their enemy leaders.
How about Johnny fighting off an army of Ronin to protect Wong? The man is a literal walking, talking, crowning moment, enough so to make glasses badass.
The climax of the Ronin mission where you go with Johnny to storm a Ronin hotel and blow it sky high. After clearing all the floors and setting all the charges, how do you get out quickly enough without being caught in the explosion? Simple: You do something straight out of a James Bond movie and base-jump off the top floor's balcony and parachute down as the place explodes all around you.
The fact that, thanks to the second game's custom radio stations, everything in the game can be done while The Final Countdown plays in the background. Or Misery Business. Or Hands Up. Or Ride of the Valkyries. Or Deadly Sinners. Or a whole bunch of others.
The whole mission "The Siege". You finally decide to cut the bullshit and go take down Maero and the Brotherhood in an attack on their compound at the docks and confront a minigun wielding Maero on the roof. The cutscene that follows is a brutal, relentless brawl between the Boss and Maero, which even if it isn't playable, is one of the most epic moments of the game, especially considering that both characters have extremely valid reason to hate each other's guts.
A smaller one before that is the mission The Enemy of my Enemy, in which Boss sneaks on board of the ship containing Maero's shipment. After killing the Ultor secruity personal the ship is attacked by waves of Brotherhood enemies from boats and boats. Boss has to fight them off. Fortunately for him/her the shipment in question is a shitload of weapons.
The entire premise of Saints Row 2 is a Crowning Moment Of Awesome. Basically, you don't have a penny to your name when you escape from prison and proceed to dismantle three of the most powerful gangs in the world along with their mega-corporation sponsor. It's like the Kingpin's version of Born Again.
The entire escape from Stilwater Penitentiary is a Crowning Moment Of Awesome as you fight your way out of the prison hospital bay and end up fending off helicopters and police boats with a boat-mouned machine gun.
Your character makes the Brotherhood leader, Maero, unintentionally run over his girlfriend, Jessica, with a monster truck.
It's even more impressive when you recognize the context. The main character is avenging the death of his surrogate son Carlos. It's Poetic Justice when you realize that Maero forced you to Mercy Kill Carlos so you force him to kill his girlfriend.
The entire Brotherhood arc is just brilliant. What makes it so good is how quickly it degenerates. It starts out looking like it's going to be the most "civil" gang war in the game, as in a "may the best gang win" kind of thing, as Maero tries to form an alliance with the Saints. Then you hear the terms of his proposal. He gets 80% of the weapons shipment and the Saints get 20%, and by extension, about 20% of the city. From there it degenerates into the most violent, personal, brutal, and outright vicious gang war in the entire game, if not the series. The Boss responds to the insulting offer by blowing up Brotherhood trucks and putting radioactive waste in his tattoo ink, burning his face. Maero and his girlfriend, Jessica, respond by chaining the Boss' protege, Carlos, to the back of a truck and towing him through Stilwater face-first. When the Boss rescues him, s/he's then forced to put him out of his misery. The Boss gets revenge by locking Jessica in the trunk of a car and placing it in a monster truck rally Maero is participating in, then taunting him about it. S/he also cripples his best friend's hand and so and so forth. It's part of what makes the fist fight between them in The Siege so brutal and awesome, they both absolutely despise each other and with perfectly legitimate reasons on both sides.
Dane Vogel gets his when Maero comes around a second time, trying to threaten him and demand more favors from Ultor. What does Vogel do? He calmly insults Maero (a man who had nearly dropped him out of the window and into his death in his prior visit) to his face, and then reveals that squad of heavily armed security have Maero in their sights. And just to put cherry to the top, he reveals that Ultor has hijacked shipment of Brotherhood goods Maero was expecting before practically shooing him away. The man can be annoying, but that moment was full of awesome.
In reaction to an ambush by the police at a night club, your character dives behind a bar using the bartender as a shield. As the police approach the bar, he/she throws a lighter in the air and ignites the spilled alcohol in a small explosion to disorient the cops and begin to get out.
Missing an obvious one here; the Sons of Samedi mission "Bad Trip" sees you fight off a massive Samedi attack on your hideout while so stoned you can barely see what you're doing.
The best part is that when you're stoned out of your mind, you actually pretend to be useless to get the villains to drop their guard long enough to escape. Yes, even when you're baked out of your mind, you're capable of being a Magnificent Bastard.
A lot of the minigames are built around Crazy Awesome. Vehicle surfing, Insurance Money, and more.
The final level of Fight Club has you fight off six guys at once. You have to finish each and every last one of them off by breaking their neck.
You have the option of seducing the reporter Jane Valderamma from her day job into becoming your psychotically obsessed homie, who says she loves you during her battles with you. What do you have to do to accomplish this? Mug fifty people.
A potentially amusing one for a male main character is the fact that he can get women to pay him to have sex during the Ho-ing diversion. This isn't a Crowning Moment of Awesome yet. However, one of the locations for this mini-game is the Barely Legal strip club. The implications? You're getting the strippers to pay to have sex with you.
The entire Secret Mission of Saints Row 2 is one long Crowning Moment Of Awesome. You and Julius get a chance to go on one final team-up together, taking on what appears to be the entire Ultor Corporation military. The tragedy when you avenge yourself on Julius, only makes the entire mission more awesome.
The Ultor Exposed mission may just be a vehicle for porn star Tera Patrick, but it has you face down a huge number of Ultor goons. The final battle has your character versus a fleet of military helicopters that he has to personally down with a rocket launcher.
Jane Valderama's handling of the story is so obvious that you have to wonder if the Boss was in on it.
She strongly implies s\he is, but then again she might just be spoiling for a fight.
Mister Sunshine's moment has to be when The General cuts his ear off. Hardly sounds awesome, but his reaction to The General drawing a machete? He stands there and takes it, making only a single grunt as his best friend saws off his ear with the blade. It just cements the fact that this guy is nobody to mess with. It also leads to this strangely heartwarming, but still badass exchange between the two.
The General: I took no pleasure in this, my friend. But a price needed to be paid for failure.
Mr. Sunshine: Don't worry. I need only one ear to hear the whispers of the Loa.