Compiz is what you get out of the box. I believe there are some other wm projects with more WOW, but you will need to build from scratch. Only GUI I have found is the very basic desktop-effects.
Use Gconf editor for more options, I currently have changed many things there... -- Rob
