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.
I can’t wait until I can buy Kingdom Hearts The Final Mixed Series in 10yrs will all the games on one disc… though who am I kidding, physical media will be gone by then.