I dropped my Canon Powershot SD750 in India on a marble floor and thought I broke a bulb in it... But I was able to fix it when I got access to proper tools (really tiny screwdriver, a magnifying glass, and a soldering iron) at home.

The switch must've taken the brunt of the fall because a little (and when I say little I mean incomprehensibly tiny) contact came loose. Pushing the contact closed caused the screen to light up... So a little solder put it all back together again:

So now I have two cameras (and thus the technology to get all Hofstadter and take a (blurry) picture of my camera)!