Every once in a while, I come up with a really good idea. More often than not, I don't.
I'm content to work on systems that accommodate the work that leads to a steady sense of slow progress. The weblog piles one post upon another; every so often, the middle of the pile is most interesting, and you dust it off and bring it out again as if it were new. The wiki appreciates it when you fix a very small typo, change an "an" to an "a", tidy up a caption or resize a photo.
Progress is more often than not measured very slowly, if at all. Just try not to go backwards.