Cmder is a software package created out of pure frustration over the absence of nice console emulators on Windows. It is a free and open source console emulation application that's portable.
Here are some screenshots to illustrate the features and user interface of this application: