There is another kind of useful-but-not-valued, and that's the person who does things that management ignores, or finds not worthy of investment of time, but inoculate against future trouble or enable other work, or make it considerably easier, down the line.
If you engage in that kind of work, it's not just that you'll not be recognized/valued, but rather - be thought negatively of, for doing that.
If you engage in that kind of work, it's not just that you'll not be recognized/valued, but rather - be thought negatively of, for doing that.