Cygwin comes with mintty [1] now, which is a decent terminal, though it doesn't match iTerm, Gnome terminal, etc. in terms of features (like tabs).

[1]: https://code.google.com/p/mintty/