“Over the years, I’ve realized that in any new situation, whether it involves an elevator or a rocket ship, you will almost certainly be viewed in one of three ways. As a minus one: actively harmful, someone who creates problems. Or as a zero: your impact is neutral and doesn’t tip the balance one way or the other. Or you’ll be seen as a plus one: someone who actively adds value.”
Chris Hadfield - An Astronaut’s Guide to Life on Earth
In any situation in life, you certainly want to avoid being a "minus one". That much (I would hope) is obvious. But aiming to be a "plus one" can lead to being overzealous, arrogant, and (paradoxically) putting us back in the "minus one" territory. This can also be paraphrased as "Don't be a Hero".
You don't get to decide where you land, by the way. If you're seen as a "plus one", that's for everyone else to decide. There is no court where you can lobby for an upgrade to the team's perception of you. So the simplest path, and the highest chance of success for everyone, is to do the work to the best of your ability. Or as Seth Godin puts it merely shipping the work.