I use it regularly (cmd), but let's be frank, its environment sucks. No tabs, resizing the window is a pain, ... and so on.
Have you looked into PowerShell? It doesn't have tabs, and its resizing isn't great, but it's a huge advance over the cmd shell language.
If you want unix command shell, install the services for unix and run the unix shell of your choice. Powershell is probably the best shell I've seen for any OS. powershell v2 will have a full ISE. I'd stay away from anything involving cygwin as there are alot of gotchas involved in getting cygwin installed and working (and I've never run into something that cygwin does that can't be done in the unix subsystem)