Here is a comparison of James Bond Vs Sherlock Holmes Vs Bourne , none of them have crossed 600 mil. (worldwide) so far.
(I know it has nothing to do with Holmes or Bourne but still, it gives some ideas about the amount of money this franchise is making)
Casino Royale
Domestic: $167,445,960 28.2%
+ Foreign: $426,793,106 71.8%
-------------------------------
= Worldwide: $594,239,066
Quantum Of Solace
Domestic: $168,368,427 28.7%
+ Foreign: $417,722,300 71.3%
-----------------------------
= Worldwide: $586,090,727
Sherlock Holmes
Domestic: $209,028,679 39.9%
+ Foreign: $315,000,000 60.1%
--------------------------
= Worldwide: $524,028,679
Sherlock Holmes:A Game of Shadows
Domestic: $186,848,418 34.4%
+ Foreign: $357,000,000 65.6%
----------------------------
= Worldwide: $543,848,418
The Bourne Ultimatum
Domestic: $227,471,070 51.4%
+ Foreign: $215,353,068 48.6%
------------------------------
= Worldwide: $442,824,138
The Bourne Legacy
Domestic: $113,161,000 42.6%
+ Foreign: $152,300,000 57.4%
---------------------------
= Worldwide: $265,461,000
It looks like SH is more popular in US as compared to Bond and Bourne franchise is Not doing that well.