I understand with what you're saying, and I agree for the most part. I just think describing this as "value" vs. "usefulness" is the wrong framing and unhelpful, and I can think of specific examples from my past that show this.
First, what you are describing in this comment sounds very much to me like following the adage "be loyal to people, not companies", and to that I totally agree. It's definitely critical in your career to build trust and relationships with folks you work with, and be dependable.
But for an example of why I think this "useful" vs. "valued" framing is wrong, I can think of a colleague at a previous company who I think was great at her role - she was a relatively junior (i.e. a couple years of experience) front end developer. She was responsive, implemented features well, and always demoed her work well and was extremely prepared. People also loved working with her - she was friendly, had very little ego, and had an almost disarming way of interacting with folks that would instantly defuse tensions on her team. I would work with her again in a heartbeat, and she was a great addition to her team.
At the same time, after working with her a while it became clear that her developer skills were limited. She was a great taskmaster, but the didn't have a great "systems-wide" way of thinking. She would implement features as requested, but when she would give demos I remember there were a bunch of times that there were semi-obvious questions ("Wait, how would the user get to screen A if they click button B first?") that she didn't bring up beforehand and did't consider in her implementations. I could trust her to implement individual components and screens, but I couldn't really say "Here's a description of the user problem, and the general direction we want to go in - how would you solve this?"
So if you asked me, I would say this person was a very valued person on her team. In her role, I think she was great. But I also don't think I'd expect her to perform well if she was asked to go in more "strategic and ambitious directions", as taken from the article.