hyperagathon: I think the Basil Rathbone interpretation of the character swung it too far onto the "cerebral" side of things. Though it's true that Holmes rarely uses violence, he's described by Doyle as an incredibly strong martial arts expert, in addition to being a trigger-happy drug addict. I haven't seen the Ritchie films, but "Indiana Jones crossed with Bruce Lee" is actually underselling him by about 50% - after all, neither of those is a genius or a crack shot.
While it's true that Holmes is able with pistols and canes, and that he has some martial arts skills (including raw physical strength), they are only marginal in his adventures. The Sherlock Holmes stories have always been about cracking a baffling case with mysterious elements (that at a glance seem supernatural) using pure logic and his knowledge of chemistry and various other fields. A steampunk action movie about SH would be like centering a
Richard III adaptation solely around battle scenes. There's combat, yes, but it's only a minor part.
Frogwares' Sherlock Homes games come fairly close to the spirit of the original stories, although some elements are exaggerated. For example Holmes would never mistreat Watson so.