What I have noticed is that often, what sleep or rest gives me isn't so much a new insight but just the gumption to make a decision or grind through what I know needs to be done.

That is a great insight. Often the thought that breaks through developer block for me is "<sigh> fine, I guess I can't do it that way"