Holmes is not an INTJ. No way.
Shooting your wall is inefficient as are many of the other things Holmes does on a whim. That's why he winds Watson up who is a J.
Also there's never a hint of ESFP.
Definitely a P, probably an NT (the amazing retention of details is more ST but I've been categorising that as his "thing", his hero piece that makes him special) and never in question that he's an I unless you ask MacGuffin who'll probably theorise he's an extrovert who got scared by mice and so hates people or some such...
Oh and INTPs are not lazy, unmotivated except by specific things is not lazy... just bloody awkward. There's a difference.
Oh and that's also a sign he's an INTP not an INTJ. He keeps correcting people.