I use Linux on my workstation, Windows at work, and Mac on my laptop. I don't get what's so terrible about the Finder. If anything, it makes you miss column view in other desktop environments (and space to preview!). [An aside, regarding Open/Save file dialogs: dragging a file into an open dialog is great, and neither Windows or Linux have been able to do copy that functionality. The best you can do is to copy and paste a path.]
I've asked this before and I've never received a list of grievances which led me to conclude that people are just not familiar with Finder.