Don't get me wrong here. I love my Mac, and I'm probably going to buy another one later this year (waiting for SnoLeo).
I hate Finder with a passion. Finder and iTunes. It's clear that both these apps were built carefully so that your average PC user wouldn't get confused. Problem is, most Apple users are not what you'd call average.
The Finder team still hasn't figured out whether they are building a spatial file manager or a browser-based file manager. The tree view sucks (and that's putting it mildly). Moving files around is a pain because (1) there's no cut-paste and (2) no "Move to ..." or "Copy to ..." context entries. Do Apple seriously expect that I'll open multiple Finder windows and then drag and drop my files between those?
I'd never even dream of using Finder for complex file management tasks (like reorganizing a photo collection). I usually drop into a Terminal when I have to do something like that.
Of course, I might be prejudiced. I used Linux for almost all my life before switching to a Mac one year ago. Also, I use Haiku on my PC, where navigating by right-click is not just a feature, but the recommended way of navigating the filesystem (if you've used BeOS or Zeta, you probably call this feature the "Z-Snake").