I had a non-working Color Classic I bought from a lady in central Austin last year that I was able to get working after a recap of the logic board. That was definitely one of my favorite time capsules.
It apparently belonged to an art student at some art university/institute in New York (I don't remember the exact one). The browser had a bunch of bookmarks for classes and whatnot; the hard drive was loaded with lots of art software, photoshop, Infini-D (3d software) and some sound software too. I was sad that I couldn't find any of their actual work on the drive, but then again it was an 80mb hard drive and there probably wasn't room for everything, and they probably wouldn't have sold/given away the machine with all of their work on it anyway. It did have some MOD (midi) music that they composed, but I am not sure if any of it was original. There was one of Depeche mode's "Enjoy the Silence" and some other generic-sounding early 90s techno beats.
The person who used it was also really into theming their mac. It had a bunch of custom icons, a platinum skin, and many other add-ons.