I've used practically all the three types, small, medium, large. I've also tried industrial standard LightPhase digital technology, medium format one shot back and large format scanback. Had my hands on a 4x5 cambo field camera before, the type that focuses with no bellows or bag, that uses a groundglass for viewing. Those were in school days, now I only have my Bronica 6x7 and Nikon F4.
I have a very old (1960s) Kodak Brownie "Vecta" box camera. It takes 127 film which is no longer available. Fixed focus, fixed aperture and shutter speed. It's all plastic, and looks quite ugly. Probably worth $10.
The web got lotsa info on how to make pinhole boxes, but if you want some more details, do feel free to let me know...
You'll get surreal, exciting and real magical images...and check out www.pinholeday.org they are having this festive exchange pinhole photos around the world now, you could make one and exchange.