Adaptational Badass: Inverted, in that while the movie's version gets into a lot more fights and makes more gratuitous use of martial arts, he lacks the original's prodigious strength and often needs to use his cunning as much as his skill to stay just ahead of his opponents. Conan Doyle's Holmes was a skilled enough boxer and martial artist to never need to stoop to combat pragmatism, preferring Good Old Fisticuffs, and was able to beat an extremely skilled boxer in a fair fight.
Cursed with Awesome: Sherlock's eponymous Sherlock Scan apparently has no figurative off-switch as shown in the restaurant scene in the first movie, and is explicitly called a curse by him late into the second.
Dating Catwoman: Played with as Irene's alignment is ambigious. He also counts as the Batman to Irene's Catwoman.
Lack of Empathy: Toyed with, but ultimately downplayed. Holmes appears to be interested in solving problems and stopping criminals mainly because he enjoys the challenge, and he also admires and respects the cunning and intelligence of the main villains in both movies despite the nature of their crimes. However, he also specifically points out to Blackwood that he wishes he could have caught him sooner in order to save innocent lives, and to Moriarty that he finds his scheme to be both impressive and horrific. Furthermore, while he has a lack of tact, he's also quite devoted to keeping his friends and companions safe.
Large Ham: Most beacuse his facial expressions and his gravely voice complete with a fake english accent.
Adaptational Badass: In the books, she was nothing more than an unusually clever opera singer who happened to get her hands on a compromising photograph, and was smart enough to prevent Holmes from stealing it back. Here's, she's a full-on professional thief and a Femme Fatale who's able to best Holmes in a fight.
Butt Monkey: He's Watson's dog, and as a result he keeps being injected with paralytics and potentially poisoned a lot by Holmes. Lampshaded in A Game Of Shadows when Watson shouts at him to stop killing his dog.
Not Quite Dead: A result of several of the compounds he's injected with.
Lord Henry Blackwood
"You and I are bound together on a journey that will twist the very fabric of nature."
The Dreaded: His influence is so strong that he causes rioting outside Parliament in the final scenes.
Evil Brit: Averted. He is evil but being british has nothing to do with it. Everyone here is british.
Evil Plan: Fakes his own death to convince others that he has supernatural dark power and assassinate Parliament.
Evil Sorcerer: Invoked but he can only fake it.. He talks the talk and uses the imagery, but his "powers" are nothing but smoke and mirrors. Though that reoccurring crow and those prophecies coming true are a bit suspect.
Good Old Fisticuffs: Relies on straightforward boxing techniques when fighting, in comparison to Holmes' modified Bartitsu fighting style.
He Looks Just Like Everyone Else: Part of his redesign from the first movie, where he was an ominous, shadowy figure. When you see him in the sequel, he's obscured by the shadows of some blinds. But he pulls them back to look at Irene face to face, and we are introduced to... an ordinary man. An ordinary Moriarty who manipulates, tortures, and kills untold numbers of people without a second thought.
No Sell: Sherlock's fight analysis/planning is useless against him because Moriarty can think as fast and fight even faster. They both conclude in their Sherlock Scans that Moriarty would tear Holmes a new one (in part due to Holmes' injury).
Tranquil Fury: Sherlock didn't foresee this, and as such had no real advantage over Moriarty in their fight.
Villain with Good Publicity: To everyone except Holmes and his allies, Moriarty is a kindly and respected professor of mathematics at Cambridge University, and a personal friend to the Prime Minister. The British government even invite him to the peace summit, not realising that it's Moriarty's fault France and Germany are at each other's throats in the first place.
Villainous Breakdown: An extremely subtle one, more to do with his actions than any expression or anger. His rage is restrained, but he makes the decision to go all-out on Holmes. And then that goes out the window after Holmes pulls off his Taking You with MeHeroic Sacrifice. His facial expression as he plummets to his death is of impotent rage.
Though Moran is shown to possess true loyalty to Moriarity, most people we seen working for Moriarty are either paid-off people or people forced to do it, who would easily squeal given the right amount of money or to get revenge on Moriarty for taking their family hostage.
Ambiguously Gay: Finds nothing wrong with walking around naked with his butler and other men, but is taken aback at the notion that women (i.e. Mary) are creatures to be admired. He even tries to hit on her using this logic, but it fails spectacularly.
Improbable Aiming Skills: When analyzing the firing distance for the Meinhart shooting (a 650 yards shot with a 7-8mph wind), Watson comments that there are only half a dozen men in Europe who could manage a shot like that, and with some additional info from Holmes singles out Moran as Moriarty's sniper. He proves pretty good on the fly, too, taking a crack shot at Watson with a rifle he scooped up while running and missing by only the slightest degree, and later shooting a Gypsy from a fair distance while suffering from a bullet wound himself.