For those that are into fashion this site (polyvore.com) will push you buttons.
Basically, it takes fashion inspiration, catalogues, creativity and e-commerce and mashes it altogether.
With basic drag and drop technology you can create your own mood boards - a dream for any aspiring fashionista or mag-hag.
Whilst the fashion space may not appeal to you, the applications for this type of technology are huge. I can see it working for music, automotive, luxury brands... anything really that has some aspirational appeal.
From a media point of view, its a pretty useful tool for creating a mood board or archetype when you don't have time to trawl through various sites for different pictures.