The Compiz (desktop effects) are really easy to use. Just install ccsm (go to the Ubunut software center and type in ccsm). Then launch it, and it is fairly straightforward from there. It is very customizable, so you will be confused what all the tiny options may do, but just play around and you will get it. When I first installed it, I wasted a good day or two playing with every setting (especially ones where I did not know what they did). I eventually settled on a much less flashy setup than the guy in the video (I dislike too many animations), but it still looks much better than Windows could ever get.
Also, I encourage you to learn to make use of the multiple desktops on Linux (IIRC OSX also uses 4). I have 4 now, and they increase productivity a lot if you use them correctly.
EDIT: If you knew that already, ignore me. I misread and thought that you were new to Linux, not just to Linux as a main OS.