Whether it’s Poirot’s vanity or Nero Wolfe’s agoraphobia, detectives have always had their vices, writes Nick Hilton. But as Inspector Rebus returns to screens for the first time since 2007, should there be a reappraisal of the troubled detective trope?