Wow, I used to work with someone who ticked every one of those boxes. Incredibly knowledgeable and spent all of their free time reading spec documents and programming. Unfortunately they could be emotionally unstable at times which was had to work around.