I think short rather than long. If it's long the player might start to lose the thrill and become less invested and excited for the conclusion. Personally I like short ending sequences since I'm so close to all the answers. I do sometimes get annoyed when developers drag out the ending by rehashing everything they've already done just to squeeze some more play time out of it.