I use MobaXTerm a lot at work. It's not quite in the same category as bash and zsh - it's a terminal, really - but it brings a lot of the Unix-y goodness to Windows.
It does tabs, and it'll connect via most protocols that you're likely to need.
Plus it comes with a built in X server, which I love - just being able to run a GUI program and have it work without having to fire up another server. :-)
We're a place where coders share, stay up-to-date and grow their careers.
We strive for transparency and don't collect excess data.