There are/were Active Desktop based animated wallpapers, though I don't know if something based on AD could qualify as "good".
Vista and later (Ultimate only) has DreamScenes (looped WMV wallpapers). Stardock has an equivalent called DeskScapes that supports non-ultimate Windows.