OSNews pointed to a nice Compiz Fusion 0.5.2 Review, showing what you'll get with the next version(s) of Compiz and the distros using it by default (Ubuntu, Fedora, Suse).