I’m probably not as talented as the author, but I can’t relate to this feeling of giving up because some work won’t be used. I have been working for ten years post-PhD and every single product I’ve ever worked on has been canned, sometimes very circuitously via acquisitions. My work is trade secret so I’ve never filed a patent, written a publication, nor given a talk. I have zero outwardly observable accomplishments.…
Everyone is motivated by different things. My strongest motivation and satisfaction comes from implementing technology to make drastic and lasting positive change in the work done by other people. Agile development methodology with iterative development and meaningful change every couple weeks suits me very well.
What you described as your work would not be fulfilling to me.