The question posed captures an oversimplification of reality. I would be considered a "rock star" by the CEO whose company I effectively destroyed by leaving. I left because there were no interesting challenges and much bigger players were offering much more money and much greater benefits. I'm dynamite at math, CS, and coding, and I'm only about 50% socially inept. ROCK STAR.
You may not need a "rock star" in most situations, but they can often be found doing the work of N > 3 people of average technical competence in companies operating on a tight budget.