Columbo

Right, but that is kind of the way almost all the 'brilliant but quirky' detective style characters almost have to be played. If it was bumbling it would be like someone leaving their plan written down in a sock drawer and for some reason he's looking for socks because he spilled something on his... Something dumb and he stumbles on it.

House, Sherlock, Brooklyn 99 (/s), pretty much every good detective story will use the fact that the smart guy finds pieces of the puzzle that others might notice but ignore, and joins them up into a plausible chain and then tests the theory against the evidence. The good ones show this play out with good theories that they have to discard before putting things together correctly. The bumbling ones need the evidence dropped in their lap, or they solve the case and don't even realize it until someone gives them credit and they struggle to understand it until sometime congratulates them. Columbia was definitely written with the former in mind.