In first part of movie Irene Adler said to Holmes, he must beware of Moriarti, because he is crazy genius. In origal book Moriarti will die in if I'm not wrong "Last affair of Holmes" part.
I wonder who will win, of course I don't exclude a fact that Hollywood will bring victory to Holmes as major hero. But who knows.
P.S: I think Dr.House is the prototype of Sherlock Holmes, Sherlock Holmes of 21st century.