I think this depends a very great deal on what your personal definition of a 'short burst' is. I know some people who will overwork themselves for weeks, then burn out and be unable to leave bed for weeks; this seems bad.
On the other hand, when I hyperfocus on something for several hours and then take the rest of the day off, I know I get significantly more and better work done than when I sort of idle away for sixteen hours, half-working and half-scrolling-Twitter.
I'm not sure why cycles on the scale of weeks seem much worse to me than cycles on the scale of hours, but one hypothesis I have is that it's about avoiding the lows going below a certain threshold. If I work very hard and am tired and hungry afterwards, that's fine; I'll rest and recover. If I ever reach a state where I'm too tired and hungry to be able to cook a good meal and go through some bedtime rituals, then I'll stop eating/sleeping properly. Once you hit a local minimum, you can be trapped there in a vicious cycle where you don't have the energy to take care of yourself properly, and you don't have any energy because you aren't taking care of yourself properly. Big highs & big lows are fine so long as you can recover from the big low and get another big high, but above a certain threshold you can't dig yourself out of certain holes without help.
If longer stretches of peak productivity produce worse burnout, then perhaps the key is keeping those stretches short enough that the burnout doesn't cross that threshold?
In my experience, I don't usually get to choose. I am ineffective and distractable when I am unmotivated, so the vast majority of worthwhile work occurs when I am motivated. Over time this has led me to "ride the tide" of motivation when it is present, and not to force it when it is not. For externally imposed work, pushing work off to deadlines has caused much less frustration than attempting to start early and work steadily. If you are not constrained by motivation, it seems like working slowly and steadily would be preferable for large projects, because it would not be as likely to burn you out. It would also be preferable for jobs, because employers and customers prefer steady, predictable progress. For small projects, and projects that benefit more from "inspiration", it is possible that short bursts would be preferable instead, because there is less risk of losing the "spark" before finishing.