I have similar experiences. Some people like to be in the forefront. Others, like me, fill in the gaps and don't care about being "seen". When I lead, it's because there's a need for my leadership. I don't micromanage. I do what is necessary for the team to perform. That's it. If someone else needs or wants to fill that leadership role, then I allow them to take the spotlight.

yup, it's easy to "do it all yourself". The real rockstars are the ones who quietly mentor the other team members over and over again until they are up to speed on their own.

I've also noticed a tendency of "rockstar" types to entrench themselves. They'll bury some esoteric process/scripting/infrastructure or combination of the three somewhere knowing that it's a bit fragile but easy to fix. All so they can just say, "I fixed it" after the rest of the engineers have been trying to keep production running for 4 days.