I haven't had used any file explorer that perfectly fits my usage pattern because usually it does not matter that much, but Finder is plainly horrible. I cannot open /tmp without using the terminal, there is no "cut" command (I know you can copy then press Alt for "Move to here", but that is non-intuitive and illogical) and the "enter" command renames rather than opens (which one is the more common operation?). These are just on the top of my head.

Basically, Finder never lets me do my work without thinking. I am always tripped one way or another, so usually I just use the terminal instead.