One thing I've noticed though - regardless of whether or not I do something about my current top most exciting thing, these things come back. The same videogame idea has been visiting me regularly for the past six months. This means that even if I lose steam after a few days of working on something, it's not work lost - I'll probably resume it for a bit a few weeks or months down the line.
On top of that, I've learned to not consider any hard intellectual work as wasted. Things I've researched for random harebrained ideas I later flaked on often find a way to become useful in my dayjob, or a different harebrained idea.