So my script:
1. connected to a database and found a list of sites it needed images of
2. checked the image table to make sure there was a recent (< 1 day) snapshot
3. if there was not, it would start X, take a screenshot
4. use photologue to compress it on-the-fly
5. save the picture
it was less than 200 lines, but it worked really well. that's still my pride and joy.
I wrote it as an exercise in functional style, and so it has no mutation (other than the tuple assignment in the main loop, which I couldn't devise a functional equivalent for). It is incredibly inefficient as a result. But it all fits in a single Python statement, save initialization!
Then once the relationships were all mapped out, I wrote another Python script to shell out C# classes for all of the tables and their relations so that I had an easy way (data library + basic web forms) to explore the data.
All said and done I think it was a shade under a thousand lines and saved me weeks of exploration and hand coding.
90 lines of code.
If you want to cut your teeth on some fun little challenges, you might try codegolf: http://codegolf.com/competition/browse