I've been using ConEmu [0] for over a year now, and it's miles better than the default console. I actually spend a majority of my time in Windows in the console now.

[0] http://sourceforge.net/projects/conemu/