My impression is that he's fairly annoying in fiction, too, though I haven't actually read the books myself. John Watson is definitely his companion in the stories, though... Well, it could be interesting to read and see what it's like.