Unfortunately I haven't seen a Linux distro with the same kind of out of the box functionality as Windows (legal issues among other things). I have heard that
Sabayon,
SimplyMEPIS, and
Linux Mint all come with fairly good out of the box functionality, but I haven't tried any of them yet.
Beryl: It is essentially a very graphical window manager. You can check out their website for more info.
Beryl-project.org
Last I heard Beryl and Compiz are reuniting.