He's a combination of all of these things. Most geniuses actually possess all or most of these traits (drug addiction, isolation, eccentricity) in reality as well. Which is why Conan Doyle's character is so incredibly realistic.

I'd say Obsessive is also a good word to describe him

Genius and madness are two sides of the same coin ;)