I don't think you're boring but I do think your brain is feeling cheated for putting in all this work over and over and not getting the dopamine rewards for it afterwards (which in most cases is often praise or money).
I think you need some small wins to keep your motivation going. I read this quote here on hacker news which was very eye opening for me at the time(1). This idealogy of using small wins while you're chasing a big win has helped me a lot when things aren't going your way. I'm a indie hacker too would be happy to tell you some strategies I've developed for creating small wins (though most of them are very specific to my product / industry so I can't say how useful it would be to you)