For every cool project, there are probably a dozen legacy programs that need work. Fixing broken can be interesting - but leadership needs to be interesting in improving things vs seeing how long they can drive it without changing the oil. Flee those organizations or be the agent of change.
Individuals can matter, but generally one has to have impact beyond their 'day' job. An excellent line order cook won't really have impact. A sous chef / master sergeant can change an org, which can also change something larger.
Don't underestimate the domain knowledge. It really helps to understand what the business actually does (or needs to do). Coding to a spec without understanding the why usually produces mediocre results, which is often the norm.