The part about open-source burnout really struck close to home for me. Sometimes I feel like you put something out there that solves your problem, but then you get a bunch of issues/PRs solving someone else's problem, and after a while it's hard to muster the will to care.
The best projects are indeed those that are tiny and maybe only matter to a small group of people. That's why I like working on Pinafore these days more than databases, libraries, etc.