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. Horatio 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.