Grand Theft Auto San Andreas/Awesome

"CJ: See you around... Officer."
 * Just Business. A gunfight and an on-rails motorcycle chase come together to form one of the most memorable missions in the whole series.
 * Burning Desire. Yes, CJ did start the fire at the Vago's house in the first place, but rushing in a crumbling building to save Denise from a fiery grave was still very heroic of him.
 * End of the Line. There's the one-man raid on Big Smoke's crack palace, and most notably chasing Tenpenny - who's driving a damn fire truck, mind you - as Sweet desperately hangs on to the ladder, not about to let him get away with everything he's done. And after having Tenpenny torment you and your loved ones for about the whole game, forcing the corrupt bastard off the bridge overlooking Grove Street is immensely satisfying. Even with the release of Grand Theft Auto IV, it's still the most exciting end to a GTA game yet.