24: Tony Almeida fits almost every part of this description in relation to Jack Bauer. This is an interesting case in that Tony initially seems like a calmer, saner, more soft-spoken counterpart to Rabid Cop Jack. But placed under enough strain (as exemplified by how they each handle the loss and/or potential loss of their wives), Tony can actually be far more emotional, reckless, self-destructive and vengeful than Jack.
Several characters have Lancer qualities. Doyle was the initial one, but for most of the series, Wesley fulfilled this role as well as The Smart Guy. Gunn also filled this role for a time late season 3 and early season 4, but was usually The Big Guy. Connor fit for much of season 4. Easily the best fit that doesn't overlap with any other roles is Spike in Season 5.
Wesley, true to the trope, was the ruthless member of the team, as well as the sorcerer of the bunch, also betrayed the gang to save Connor, stabbed Gunn and shot Knox during his Roaring Rampage of Revenge, and, being the less stable of the group due to Fred's death, was expected by Cyvus Vail to make a move for Angel's position. Aware of it, Wesley pretended to be planning to betray Angel in order to get close to Vail and kill him. As the trope goes, Wesley was killed by Vail instead.
Cordelia was Interim Lancer between Doyle's death and Wesley's integration into the main cast, and was always Angel's real foil, despite being The Chick throughout.
Garibaldi is more aggressive than Captain Sheridan, prone to independent action, more of a covert operative, and does indeed get brainwashed at one point.
Ivanova is the pessimistic - sorry, make that Realisticdry-witted executive officer. She's remarkably tenacious, hammy when angered, and a spy master on par with Garibaldi at his best. Her fiery personality particularly contrasts with the original commander, Sinclair.
CSI: Miami: Ryan Wolfe has qualities of this. However, Eric Delko is a better example of the Lancer to Horatio's hero. Womanizer, leader, outgoing, and willing to take initiative on his own to further the team. Add to that he's completely loyal to Horatio.
Captain Jack filled this role during his short tenure.
Doctor Who usually has a small ensemble, but groups exceeding three members would occassionally contain Lancers; for example Rory Williams and Ian Chesterton, both more 'classical' heroes in contrast to the Anti-Heroic Doctor.
Gobo, the reluctant leader of the Five-Man Band, had two extremely opposite Lancers — his best friend Wembley and Wembley's constant rival Red.
Although they get considerably less screen time, the Minstrels are a clear cut Five-Man Band, and it's obvious that Murray acts as the Lancer to Cantus.
Hotel Babylon: In this British series, the concierge Tony is a seasoned pro at the hotel business and very well-respected among his colleagues. When a general manager strays, he's usually one of the first to stand up for the good of the hotel or its staff and let a manager know he's going in the wrong direction.
Foreman is the subordinate most likely to oppose House on any given matter, and in later seasons has become the de factoNumber Two of the team (having stepped into the position of leadership on three separate occasions). Though his characterization has emphasized a fundamental similarity between himself and House, there are important (perhaps deliberate) differences — Foreman is stuffier than House, presenting an air of consummate professionalism in contrast to House's slip-shod and free-wheeling style of management.
Inspector Lynley: DS Barbara Havers to the Inspector; she challenges him at every turn and is the first to tell him when she thinks he's being an idiot. She would also follow him into fire if he asked her to, and anyone who challenges him will find themselves on the wrong end of her fury.
Leverage: Sophie most cleanly fits this role, often serving as a foil to Nate in the planning process, though the rest of the crew also occasionally fits into it at times. Eliot in some ways fits this role, as the opposite of Nate, preferring to fight his way out of situations then Nate's Chessmaster style. Parker in some ways fits into this as the only true thief among them, as well as being a skilled planner when it comes to heists. Hardison also is trying to develop the skills to run his own crew as well.
LOST: Locke and Sayid alternated on this role towards Jack until Locke leaves the group in season 4. Ana Lucia also served as this for a brief time in season 2, before she was killed by Michael.
When Jack and five other survivors leave the island in the season 4 finale, Sawyer becomes The Leader with Juliet as The Lancer. In fact, Juliet's "I have your back" to Sawyer and acting like she meant it became a pretty important part of season 5 that leads to the two of them getting together.
And talking about Jack's group in season 5; Sayid, taking jobs for Ben as an assassin, becomes The Big Guy, which moved Kate to The Lancer of the group.
Season 6 had the people on the island divided in two camps: Jacob's group and the Man in Black's group. Ben served this purpose to Ilana/Jacob's group as of "Dr. Linus" (Ilana didn't really trust him earlier than that), while Claire and Sayid alternate to serve the Man in Black as this.
Mash: Trapper John (seasons 1-3) and B.J. (seasons 4-11) serve as this to Hawkeye.
And even Abby, usually The Heart, will go that way.
Noah's Arc: Ricky, as a very clear foil to Noah. While Noah is very moral, relationship-oriented, romantic, and holds the group together, Ricky is much more pragmatic, highly promiscuous, sexually detached, and more than willing to abandon the group over a one-night stand. The stark contrast between them is lampshaded by both of them at different points in the series. Also, Ricky, Noah and Wade are involved in a love triangle highlighted in the movie.
The Office (US): Jim is briefly promoted to co-manager and tries to be a lancer to Michael, tempering his need for fun with a need for work.
Once Upon a Time: In season two, Red is this to Charming's Hero, especially with Snow stuck in the Enchanted Forest.
Revolution: Miles Matheson is the opposite of Charlie Matheson. He's older, smarter, more cynical and more experienced compared to her.
Roswell: Michael frequently plays the classic Lancer to Max's Hero, as both lifelong best friend and, with his loner persona and occasional need for anger management, as his foil. Michael even briefly assumes the role of "king"/leader after Max's "death".
Smallville: Clark has had a few Lancers in the ten seasons of the show. In the first few seasons it's Lex, his best friend and counterpart who is often portrayed as somehow being both Clark's polar opposite and kindred spirit. Once Lex starts to go evil, Oliver takes over the role.
Star Trek: Spock is all over this trope. Indeed, he is by all counts equally as competent as Kirk. But where Kirk will go with guts and daring, Spock will always be cool, calculating, and logical. And yes, when the chips are down, Spock is ready at a moments notice to die for the cause (as seen in Star Trek II). Also, in cases where Spock devoted most of his screen time as The Smart Guy, Dr. McCoy picked up the role.
Star Trek: Deep Space Nine: Kira is Sisko's lancer in every aspect of the trope. If it were up to her, there wouldn't be any Starfleet personel on the station and she would be in command. In early seasons, she's yelling at Sisko every other episode and often completely ignores his orders when she believes she can handle things better. She grows to trust him in later seasons, but she always remains the person who challenges the captain's orders the most—somewhat unusually, considering that, as the Emissary of the Prophets, he's the equivalent of a saint or prophet of her religion.
Riker was intended to perform the action roles that Picard (as The Captain) really should not be doing. Especially in season 1, he was a Kirk clone. After Growing the Beard, his role on the bridge was to anticipate Picard's orders and issue them so that the captain wouldn't have to.
Contrasts with Picard in Riker being a womanizer (Picard is not very successful with women) and somewhat impulsive (Picard is fairly cautious). Riker also fits the role in easily being the more gregarious and social (he plays in the ship's jazz group and runs the senior officers' poker games) while Picard is the more private and prefers solitary pursuits such as reading and archeology. Oddly enough, while Riker is obviously supposed to be the more physical (being younger and larger) compared to Picard's more intellectual, Picard tends to be the one who ends up in the most physical confrontations over the span of the series and movies.
Star Trek: Voyager: While he's not the first officer, Tuvok fulfills this role for Captain Janeway. He's calm and rational while Captain Janeway is usually very emotional. In later years, Seven of Nine plays the role.
Top Gear: Richard Hammond to Jeremy Clarkson. Hammond is a head shorter, a decade younger, and physically tough but emotionally fragile compared to Clarkson, yet they are inseparably bonded by a mutual love of fast, powerful cars. The third presenter, James May, acts a bit like a Lancer to Clarkson but they are more of an Odd Couple.
Torchwood: Owen falls under this fairly well, at least in series 1. Owen is The Lancer to Gwen while Jack is away. When Jack returns, Gwen becomes his Lancer.
The Walking Dead: Shane Walsh for the first two seasons. Daryl Dixon from season 3 onwards. Until season 3, Andrea is this to Lori for the women.
The West Wing: Leo is a dead-on Lancer of the Blue Oni type to Bartlet's hero. Being The Lancer is also Josh's calling in life, according to Bartlet: "You know the difference between you and me? I want to be the guy. You want to be the guy the guy counts on." In the later seasons other characters lampshade the fact that Santos, to Josh, is his opportunity to be what Leo was to Bartlet.