The unproductive ones that invite for coffee, make jokes also have successful careers as they are perceived to be - friendly, high in openness, and high in consciousness. Now, I'm skeptical of your claim that these people are unproductive, not sure whether such an individual would survive a highly competitive environment. I could argue that they are productive enough to have time not just for work but also to engage in things outside of them.
I'm that type of person, my career growth has improved tremendously due to this ability of mine though it is natural for me to engage with people in my workplace. I am the guy people come to build XFN features and products because everyone knows me and I don't come off as a threat. This is a huge plus in large-scale enterprises where each BU works as a startup of its own and collaborating with them becomes a hassle.