Ann Hamilton did an entire series (Face to Face) of pinhole photographs using film cannisters, you can see more here: http://www.pbs.org/art21/artists/hamilton/clip2.html

if you're looking for more pinhole information (camera making, viewing images, etc), may I suggest the f295 pinhole photography forum... f295.tompersinger.com

cheers!
tp