You can use the console application for things that you don't wish to load down with a graphical UI. For example, if you are making some sort of server application that doesn't have any sort of user interaction, you may wish to make it a console application so as to enable basic statistical output or errors or whatever.
There isn't really any time you need to use a console application, it's just that you can use it if you don't need controls.