Earlier quoted context omitted.
I think people with this attitude would be really pleasantly surprised by PowerShell and Cmder. Windows makes a very bad UNIX, but it has a great command-line story these days if you'll play with it on its own turf.
Pleasantly surprised by powershell? I don't know what to say. I have to essentially copy and paste fragments of things that work, it's so arcane. Its like writing 90's Java on a command line. Its revolting. Still to this day I can't even fscking grep.
I have about the same problem when it comes to bash. While bash may very well be described as "arcane" I believe this is mostly a problem of unwillingness to learn something new or different.
Understanding how PowerShell works takes a bit of time and re-thinking. It doesn't help that there's so much downright bad PowerShell code out there that was mindlessly converted from VBScript. Still, it's not that hard and the language is quite consistent and, well, powerful. They made quite a large effort to make sure that the underlying concepts are orthogonal and pervasive throughout. So learning just a few concepts actually make a very large part of the shell and language approachable and easy to understand.