Well, a year has passed since this thread started and we now have Mavericks which added tabs to Finder but removed the "Open in new window" shortcut. (Apple gives with one hand and takes away with another). I create a new tab and then drag it away to make it a new windows, but that is an extra step.
I use Windows, Mac OS, and Linux every day, so have been acclimated to the features, mis-features, and various shortcuts in each. I've used Macs for I guess about 8 years now and used Windows since the beginning.
As far as I'm concerned Finder has a certain elegance to it. Windows Explorer just seems to use too much screen real estate to accomplish the tasks. That tree view in Windows, I always find it getting in the way and turn it off -- it's called the "Navigation Pane" at least in Windows 7. I do know that I can get the task done faster with Finder. If you are coming from Windows it's important to remember that OS X is not the same and learn how to use it.
I do have Pathfinder and Forklift, got both in packages. I have found Pathfinder useful for changing extended attributes (something finder doesn't do) and permissions (which can't be handled as thoroughly in Finder) but otherwise I find it too bulky. Forklift I use for SFTP access to remote systems, for which it is very handy. 99% of the time I just use Finder.
I haven't mentioned Linux here. I've found the file browsers in Linux to be generally horrible and almost always just work from the command line which is also easy to do in OS X, less so in Windows.