I started out really enjoying Sherlock. But every successive series/season got worse and worse. This is a Moffat thing. As pointed out here, he's good at short, contained things and terrible at anything that requires long-term plotting and planning.

To be fair, I don't think people watch Sherlock for the mysteries. People like the characters. Still, it would be so much better if the characters had better stories to act out in.