Read up a bit on ADHD. That 'hyperfocus' that occurs either with deadlines or on a passion project is a symptom, as is the inability to get excited about projects you simply don't want to do - especially given your otherwise positive reviews and your ability to clear your mind and hyperfocus near a deadline, it's something to consider. I was diagnosed at 33, and it changed my life infinitely for the better. YMMV, and…
Isn't it just rational not to get excited about boring stuff that is rewarded by a fix monetary ceiling? Economically it completely makes sense: why put more energy into something that yields the same result either way? Or maybe I have ADHD too.
this video does a good job of explaining the motivation problem when you have ADHD. https://www.youtube.com/watch?v=OM0Xv0eVGtY