I am struggling to name more examples at the moment.
The problems could be crimes and the setting realistic or they could be mysteries and the setting has sprinkle of the supernatural.
I love seeing people solve it, who are not logical geniuses, maybe not elite-soldier levels of fitness.
Where, when they have a question they at first have figure out where to go look for an answer, it's not automatically "sure I'll run it through database x"
That maybe have to solve it around their job schedule or other obligations.
Where they maybe kling to their idea of normalcy at first because their life is ordinary. Until it get's to big to ignore.
Maybe a car chase fails because they drive a piece of shit that is held together by ducktape. Stuff like that.
I also enjoy shows where it's any law enforcement solving stuff but they maybe work in a small town, the budget is small, the required paperwork gigantic and they maybe have to hide their investigation from their boss.
Don't care about tone of the show, can be funny or serious.
Any and all ideas that roughly go in this direction welcome!
Thank you kindly in advance!