CSI: Miami: Horatio Caine spends most of his screen-time trying to pull these off. Most would dispute that he succeeds all that often, though one time he does: "All In": Cornered by four gangsters with automatic weapons in Brazil, Horatio, who speaks fluent Spanish, responds "Como?" to their Portuguese threats. In the instant their leader turns to share a taunt about the stupid gringo, Horatio has already shot three of them dead, then proceeds to cut a trail of death and destruction clean back to Florida.
In that same episode, the guy who took Calleigh hostage takes her to the illegal poker game he's planning on robbing. He shouts at the players to hand over the money, only the camera pans around to show Delko, Wolfe and Tripp... who draw their own guns. The guy threatens to shoot Calleigh, but a Click Hello from Horatio ends the standoff.
Calleigh used her forensics knowledge to lead the others there too.
In the episode "On The Hook" a corrupt parole officer is just about to rape one of his clients in his trailer, but then Horatio comes in and rips him off of her before pointing his gun at the guy. The guy mockingly asks Horatio if he's going to kill him. Horatio replies, saying that while it's tempting, he'd rather give the guy a taste of what the rest of his life would be like, and promptly throws the parole officer out of the window.
Season 5, "Curse Of The Coffin." In the side case, Horatio finds a bomb planted in a "bait car" (designed to collar carjackers) as part of a revenge scheme to kill the officers who arrested the criminal's cousin. Its only got four minutes left on the timer. There's not enough time to disarm it, so what does Horatio do? He gets in the car and drives it as fast and far as he can to get it away from civilians. It explodes on time, and just when it looks like no one survives, we see Horatio, walking calmly away as the car burns violently behind him.
In the season 10 opener, Horatio (while dealing with a shot to the stomach), manages to stop an escaping criminal by means of an elbow to the face.
In the season 9 finale, Horatio has an opportunity to take revenge on the guy who shot his late wife, Marisol. He looks like he's going to send the guy to his maker, then manages to calm himself down enough to turn the guy over to the proper authorities.
In the season one finale, Horatio and Calleigh each get one. There's been a jail break, and two of the escaped cons have vendettas against the team (Hank Kerner is after Calleigh because she could put him in the electric chair with her testimony, and Stewart Otis is a child molester/killer who wants to hurt Horatio). The moments are as follows:
Calleigh refuses to sit out of the investigation, and instead catches Kerner at an ammunition store, managing to sneak up on him and disarm him. After he drops his gun, she presses hers into his temple and snarls "How does it feel?" Quite the badass moment for such a normally sunny and cheerful character!
As for Horatio, first he rescues Otis' initial target (she had been buried alive but he got her out just in time), and then he manages to find Otis at the aquarium, where he was going after his second target. There's an excellent shot of Otis watching a shark with a dreamy-eyed expression... and then he turns to see Horatio glaring at him in a way that would make a Great White envious. After a brief chase, Horatio manages to catch Otis, who falls over the edge during the scuffle. Horatio pulls the guy to safety, even after Otis slashes his hand twice. As Otis is being arrested, he tells Horatio that he'll get out again, because it's his nature. Horatio replies "And I'll be waiting, because that's my nature."