It's just a different set of skills and you create value/feel rewarded in a different manner. It's not better or worse, it's just different and appeals to different kind of people. Take some other example from video games:

- Why would anyone pick a healer in an MMO group ? What's so great about becoming a healer ? How's that better than playing a DPS, actually contributing to killing the boss and letting someone else worry about your health bar ?

- What is fun about plying support in DOTA ? I mean the fun is being the carry and killing everyone on the other team to win games ? How can anyone willingly waste his gold to buy visibility wards, that is really not fun at all.

The healer/support/manager (="helper") position appeals to people who like to focus less on the pure "productive" task at hand. They like to focus on getting a full picture of everything that is happening, anticipating potential issues, fixing them, and allowing the DPS/carry/engineer (="producers") to be in the best possible position so they can perform their job. This can be fun for some people even if you don't see it that way. This often is really not an easy task. This often is critical for the success of the team.

And just like there are good and bad "producers" there are good and bad "helpers". The skillset is different, the measure of value creation is different, and the fun is different.