I was really suprised at the end of SNL when they showed the Muppets with the puppeteers. I had never seen that before and assumed it was a bit of a no-no pulling back the curtain on the illusion and all that.
It's happened very, very rarely. The only other time I can think of, off the top of my head, was at Jim Henson's memorial service.