During TAB, Sherlock can be seen as good as well as a bad detective.

Bad detective:

Just about every person from Sherlock´s surroundings considers him a crappy detective in his mind palace.

John boasts that he "persuaded the reading public than an unprincipled drug-addict is some kind of a gentleman hero" and makes many remarks from which we could discern that he consideres Sherlock a looser junkie rather than a detective.

Mary mocks him that he is not the clever one of the two Holmes brothers, openly tells him that she was deployed to guard "Mycroft´s mad brother", solves the case of brides for him etc.

Mxcroft has his usual sneering, malicious fun at Sherlock´s address.

Sherlock, "the most observant man" doesn´t recognise that Molly is a woman there in the morgue.

In the Carmichael´s house, he somehow doesn´t pay any attention to the tracks of boots the perpetrators had to leave on carpets and in the rest of the house (the kitchen where John waited had to be full of them, IMHO), he doesn´t notice the shattered glass on the ground of the courtyard (I cease to believe brides managed to carry it away) etc.

He makes the weird deduction that the bride lurking inside the house can only leave through the window which he himself had broken. While in reality, in a house that big, the "ghost" could unlock any door or a window from inside and escape.

He weirdly leaves aside the fact that both clues discovered only after the bodies were already seen without them (the brides red finger, the "miss me" card) are the clear indicators of "the inside job" - the crime being perpetrated by people working in the morgue and in lady´s house.

Good detective:

Very early in the narrative, Sherlock makes remark that instead of Emilia Riccoletti, mysterious murders are normal domestic murders being blamed on a ghost. This is absolutely correct.

Sherlock immediatelly recognises Mary while John doesn´t.

I have a feeling that after seeing the red stain in a carpet in front of Lady Carmichael, Sherlock immediatelly figures out that she is the perpetrator of the crime.

In the long run, we find out that Sherlock managed to solve the problem of Moriarty´s reappearance in less then ten minutes, while unconscious.

So what is your impression? Was Sherlock presented as a good or a bad detective in the story?