I've used the various themes and plugins to add cool effects to windows and such. Its not really worth it, the performance hit and resource requirements go through the roof.

Vista, OS X and Compiz do it all on the video card, resource use for OS X and Compiz is generally under 300mb total. Vista's cache scheme makes it take up every bit of memory it can find, it only releases it when another app asks for the memory.