Interestingly, all these things, screwed up credentials, weird refresh issues when editing network file names, hang-ups, all happen to me on Windows 7, too.
My biggest issue with my Mac was eventually working out that my Ethernet over Power bricks don't actually forward any mac networking info, so networking only works properly over wifi for me at home!
Finder is rubbish windows 3.1 is better
Despite no arguments or valid reasons in your post, Windows 3.11 that I used actually had a really good file manager, FileMan.exe which sadly disappeared after Windows 95 some time I think? Or was it 98?
It was really fast. As would be popular these days, it was WHITE everywhere and everything was FLAT.
That was the point finder is still not as good as the first good filemanger windows had let alone the Amigas.
I would cite regular frustrations with finder I wish I had been more assertive and suggested a move to windows server and stopping buying any macs at my curret place would make my job a lot easier and save money!
But, what iritates me is very poor handling of network shares. Those are critical to me, and it just won't work perfectly. On a previous job there was a windows share that could be browsed in command line but Finder wouldn't open the folder.
Or the credentials would get messed up every once in a while, with old values filled in when I logged in with the new credentials so many times already.
Or the Finder would go beachballing and stop responding when an nfs share is disconnected while navigating it in the Finder.
Or the list view refresh on a dropbox share while renaming a file, which can result in a partially typed file name getting commited automatically.
I hated windows, but I have to concede Explorer was rock solid and basically bug free in comparison.