Take a look at the new site - an external facing internet site created for the Australian goverment to spread news about the Indigenous Australian related projects. My company, Extelligent Design, helped build the site which includes such features as tagging (with a custom built tag cloud), content query web parts and jquery picture library slide show components. I have helped write some of the components above as part of my day job.
Update: I was asked what the slide show component is - the answer is not flash, nor sliverlight - but a jquery script called galleryview (http://www.spaceforaname.com/jquery/galleryview/) that we customized for our needs (different CSS, do not show descriptions and so on) and then embedded in a web control that pulls information from a picture library, formats it as a UL list, and then uses script to show it as a slide show. Easy, and accessible - because even if you don't have javascript enabled you see the picture as a UL list (which is shown anyway at the bottom to make it accessible for other people).
