This feature lives up to the hype: The work Microsoft has done is stellar. There are an awesome collection of Backgrounds and Themes included with Windows 7 and others you can download free. Also, the new desktop slide show can display a rotating series of pictures (either yours or Microsoft’s) - yet one more reason to like the Aero interface.
Check out the available Themes and Backgrounds on Microsoft's web site for more information.