Holmes is very episodic by nature, which lends itself well to this structure. Even the ones that aim for an overaching story lean heavily into the “mystery of the week” for story structure.

It probally would work for things like the above, but can you honestly see long form shows working in the same way?