I'm looking for a utility that will help me in keeping Finder windows hovering about all apps. Anyone heard of such?
.. does exactly what you want.
You can pin windows to be always on top of others. This includes all possible windows, not only Finder ones. There does seem to be a hiccup with Finder – you might want to look at this guide for more information. Basically it should work in Snow Leopard. For a list of apps that won't work with afloat, see here.
Btw: Another nice feature: