I'm much the same. For me, though, the best all-nighters have come from when insomnia hits and I can't stop thinking about a bug. Then I cave in, get out of bed, and hack away.

It's essential to have a flexible employer though.