Dirk Gently's Holistic Detective Agency has got you covered.

Orphan Black did a bit kind of like this with a character named Krystal

Tom Selleck played private detective Lance White on 'The Rockford Files.'

Lance was Jim's opposite in almost every way. He had a great relationship with the police; never lost a fight; never worried about money. He'd come up with a theory out of thin air and always be right.