Vista had DreamScene (or LagInducer) which let you play a video file as your wallpaper...

I think it was scrapped in one of the service packs.

Hey actually, in Windows 98, since it's got the web embedded on the desktop, you can set an animated gif as the wallpaper with Active Desktop enabled.