Often described as "long-suffering," Mrs. Hudson is Holmes' landlady and housekeeper, and puts up with her tenant shooting patterns into her walls as he sits idle and bored.
My landlord when I was in college, a psychiatrist whose name I can't recall, put up with similar antics from me with far less fluster than did the great detective's. I had a habit of sitting on my couch on the opposite end of a very wide room and shooting from the hip with a Red Ryder bb gun at a full paper towel roll that sat on my entertainment center whenever I was watching tv. As a general rule, I was a decent shot, and would usually hit the roll, send it spinning (its weight was such that it would usually remain upright after), and try and hit it again before it stopped its tilt. I wasn't infallible, though, and the wall behind it was peppered with small holes. The wallpaper was so thick, having been covered and recovered for decades, that it would have a slight give if you leaned on it, and the bbs would embed themselves deep.
I'm pretty sure that the landlord had written off the place as a lost cause long before I'd moved in, so the leeway I was afforded was likely not a reflection of any personal magnetism.