Be so good they can't ignore you

So I've been reading this new book and the author says that your job should not have those 3 things:

• There is not growth opportunity
• Your work is useless or bad for the world
• You work with people you dislike

In other to success you need to gain experience capital and be rare and valuable. So, how can this happen in networking? CCNA/CCNP is pretty common now, CCIEs are losing their value because of all the software and cloud automation coming in. What's the good niche to be in the be a rare expert?

PS: I feel like people peak at CCIE, become 6 figure consultants and that's it. Is this really it? Is there a way to grow more. I'm not money hungry, I'm curious of the opportunities this can lead to.