There is a mix of both throughout the show, especially in the Irene Adler The Woman episode. You already know she is behind a few criminal things from the start. There is also another case within that same episode where someone died next to a river, and one of the draws of the case is that Sherlock figured it out instantly, but doesn’t want to tell anyone what the answer is. It is slowly revealed in bits over the episode of what he figured out.
I may give Columbo a shot since it’s an older show I have put off trying. And Monk has also been sitting on my list.
This is one hard to say. Dark is one of my favorite shows, but I do think the journey is better, the journey is kind of the process for the acceptance of the finale, so it does make sense.