Nerd / geek / spod / dork etc., very complex shifting meanings.

But what you're talking about in the first paragraph is what people used to call "geek" culture, and what you're talking about in the second is what people tended to call "nerd" culture.