Rather than reply to the comments left on my last post I’ve decided to write this so more people will see the answers. First of all, my source of info is me. I’m on the compiz team in Ubuntu.
We’ve fixed the Intel driver so compiz+video works there unless you have a 965 (x3000 or x3100). If you have one of those compiz will refuse to start now. That is actually how we are dealing with most of the driver and/or hardware problems right now. We’re just blacklisting cards that have been known to have problems.