This one's courtesy of Hal...
XtraFinder brings extra features to Mac Finder, such as:
Arrange folders on top.
Maximize on Zoom.
Automatically arrange items by Name in Icons View.
"Copy Path" menu.
"Show Hidden Items", "Refresh"... actions.
And more to come.
This is a
0.1 beta (OS X 10.6.6 and up) from a new developer, it looks like it's going to be a gem, and I don't expect it to stay free.
At the moment, a "Folders on top" sort only holds for about 10 seconds, so if that's what you're looking for, be warned. ("Show Hidden Items" works in a flash...without quitting Finder.)