You can use the console application for things that you dont wish to load down with a graphical UI. For example, if you are making some sort of server application that doesnt 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 isnt really any time you need to use a console application, its just that you can use it if you dont need controls.