Most of the time I found myself working with Console application in .NET Framework is when I want to create a spike / test on a concept or idea.
Really... what is there to be excited about the old plain Console?
All you do mostly is: Console.WriteLine(...), yes? And maybe a Console.ReadLine() at the end to stop the Console window from being closed automatically before you can see the results you want.
This is all too true in .NET Framework 1.x....
But not in 2.0...
Perhaps it's just me, but I didn't really bother looking over what's new in the Console class until recently. And to my surprise. They added a lot of improvement into the class. Like the ability to position the cursor, changing color, etc.
Take a look here: http://msdn2.microsoft.com/en-us/library/system.console_members.aspx
Being the geek that I am, I couldn't help myself but being excited when I discovered this. Even if it is not truly something new, but it brought back a lot of memories, a trip to memory lane if you will, to the days when I was still doing DOS based development in Pascal, QBASIC, and the like. Creating my own windowing framework and control libraries in QBASIC and Pascal 
Oh... what fun