Utterly dopey characters who are actually very good at their job

Similarly, On the Fastrack has Art Welding: a good coder when forced to be and even better at testing anti-virus capability – by letting the viruses in. Then the pandemic hit and virtually everyone starts working remotely – suddenly Art’s productivity rivals that of Wendy, his executive-assistant wife.

Wally’s not incompetent; he’s lazy. And if you must do a job, doing it right is a lot less work than doing it wrong. Laziness is an asset for a programmer.

The show, when it started, was a mystery about a amazing detective with quirks. Later, it became a comedy about a quirk dude who did mysteries. I stopped watching.

Archer was the first one to come to mind.

Riley: No, you just killed like, ten pirates.
Archer: Wow, and if the five-year old me knew that he would get a huge boner. No idea why I said that.