My day job. Personal projects get a little more heart, but "success" to me is usually intrinsic, not extrinsic. I'm probably a little weird when it comes to motivating factors, but not alone.
Oof. This is probably most people, too. There need to be more jobs where the interest alignment in work is 100%. Disney animators, Nintendo programmers, audio programming, SpaceX engineers, ML/AI, bioinformatics, ... Rockets, chemicals, machines, visual toys, solving moonshot things, ... Less plumbing and glue code. Less adtech. Less studying and optimizing trivial human interactions that nobody will remember.
But "anything I do for work" was my first thought when I saw this post.
What it comes down to is that there's only so much I can do to help my work's projects succeed. There's just too much out of my control. Decisions have already been made; contracts are already being signed; the clients believe they've done enough testing.
I can pick up the slack, go above and beyond, and do other people's job. But the project can still fail to get user buy-in, fail to make any notable impact, fail to make or save money, or just outright fail for reasons I can do nothing about.
That doesn't mean I don't try. I just don't care if these projects succeed. If we did what we could and learned things we can carry forward, I'm satisfied.