Mac OS uses the 'shrinking window' effect to show you where your window has gone, and drop-shadows to give you a sense of depth. Translucency in menus gives a subtle feeling of impermanence, and subtle transparency emulates the effect of paper-on-paper, where you can kind of, but not quite, make out the letters on the page below the one you're viewing.
Compiz, however, seems to be based on the philosophy of 'Now that windows are textures, we can do arbitrary transforms on them' and throws in a lot of effects that make little sense. Menus that wobble into place, windows that behave like they're made of Jell-O, and so on. They're neat conceptually, but I tired ages ago of people pointing out how Linux was better because I could configure my windows to burn up in a puff of smoke whenever I closed them.
Sure a lot of the stuff Compiz is silly. Granted that wobbly windows is a wow factor thing, but why not? its the little nice touches that keep peoples interest in things, and makes it an enjoyable experience.
Although I remember seeing an old Windows 98 box in my JCR's office... With a 800x600 CRT monitor stretched to a 1024x768 resolution. It made your eyes bleed.
I'm really glad that there's still a bunch of people on XP; it means that I don't have to bother upgrading, because anyone who targets Windows has to support XP. Sure, it's old and clunky, but that's what it's for: to run programs that are old and clunky.