Beryl and Compiz Fusion used to be two different things, beryl was a fork of Compiz. However, both communities have joined back up and Compiz is the package and compiz-fusion adds some additional functionality.
I've been using this stuff on my Linux boxes at work for quite some time. Windows users are always impressed when they see me running on an older box with an Nvidia FX5200 graphics card and I can run circles after the Aero interface in terms of cool eye-candy stuff.
That video only scratched the surface of what is available. I've got 16 virtual desktops on my Ubuntu box at home and instead of a cube that I can spin around, I have a round cylinder with all of desktops. It looks pretty cool.
I'm not aware of any specific add-on to Windows to provide this level of eye-candy.