Yes it comes and goes. Can't deal with it really, I've seen all the advice but when to rollercoaster starts ascending theres nothing I can do really. Evertyhing just sounds like shit and I feel worthless.
Sometimes I feel super motivated and I try to make the best of those times.
All this goes hand in hand with my real life (not related to music). If things are going well then music is more enjoyable but when the depressive times hits, well, havent found a solution.
It happens to us all... I think the more experienced you get, the more rarely you get this. Also when you produce consistently it will happen less.
Second to that, I also think that other things that are happening to you in life are causing it as well.
For me, its quite the other way around. When I was starting out I rarely got too overwhelmed about music related stuff and everything was pretty fun. Now as I get better the frustration and angst increase. It's getting worse every year as I get better.