The 'Jerry Springer Nudity De-Mosaic'
Image Stack Fun (Photoshop Extended)
My Photography Mob gallery
and for a more practical application...
High ISO Noise Reduction by Image Averaging
Lets say you are in a museum: no flash allowed, no tripods allowed, but photos are allowed.
You can take a bunch at high ISO and average them together to get rid of the noise.