It's mainly useful for automating chunks of documentation.
Markdown files on GitHub for example don't support any form of templating language - but Cog is a template language which can be hidden away in <!-- comments --> in your Markdown, and then executed using a separate command:
cog -r README.md
So it's a templating language for files that don't usually support templating languages, but that do support comments.