I do not think that this is much of a problem on a challenge level.
So the player plays a PC that has a very high Passive Perception and Passive Insight value. His PC detects hidden things and detects lies and motivations.
Now, in the novels, the reader is amazed by what Holmes detects that others cannot detect. Holmes himself, however, is not amazed by this at all. It is normal for him. Instead, the challenge for him lies in having to identify the meaning of what he detects and how it all fits together.
And this is the shift you should make in the game. Detecting itself does not become the challenge, identifying the meaning is.
A few examples: a thug is hiding. What do we do about it? The minister is lying. Why? There is a trap. How can I communicate this fast enough to the party? How do I deal with the trap? Etc.
The real problem in my opinion could be with other players at the table. Because if they do not want that shift but want instead to be challenged by stuff, the cannot detect, than this becomes a problem. But this is nothing you have to deal with while conceptualizing a scene. Instead, you need to talk to the players about this. If they are ok with it, then this thing is resolved. If not, will the player of Holmes want to change the PC? That is the real problem, IMO.
So the player plays a PC that has a very high Passive Perception and Passive Insight value. His PC detects hidden things and detects lies and motivations.
Now, in the novels, the reader is amazed by what Holmes detects that others cannot detect. Holmes himself, however, is not amazed by this at all. It is normal for him. Instead, the challenge for him lies in having to identify the meaning of what he detects and how it all fits together.
And this is the shift you should make in the game. Detecting itself does not become the challenge, identifying the meaning is.
A few examples: a thug is hiding. What do we do about it? The minister is lying. Why? There is a trap. How can I communicate this fast enough to the party? How do I deal with the trap? Etc.
The real problem in my opinion could be with other players at the table. Because if they do not want that shift but want instead to be challenged by stuff, the cannot detect, than this becomes a problem. But this is nothing you have to deal with while conceptualizing a scene. Instead, you need to talk to the players about this. If they are ok with it, then this thing is resolved. If not, will the player of Holmes want to change the PC? That is the real problem, IMO.