Having read existing answers, I think I agree with Emracool's. There's a variation here I'd like to discuss, though.
The fault of the question (IMO) is that it's asking for a complete history of all places Holmes storylines could have pulled inspiration from and anything based on it after the fact. This is very List of Things and not really about puzzles; it seems to be more about the history of what was done with a Sherlock Holmes plotline. (Maybe suitable for a books SE?)
If instead the question had been written like this:
My favorite Sherlock Holmes story was Story X. Are there any puzzles out there that use similar devices or draw from the plotline of that story?
I would call that a legitimate identification question. You're looking for a specific puzzle category you think you'd enjoy. You might get one puzzle or a few dozen or none, but you're focussed on the puzzle, which is what the site should be about.
But I think I agree that the question as it stands doesn't fit; it's not about the puzzles, really, but the borrowing-of-material. The OP's intent is different in each case, so I feel one is on topic and the other is not.