Not quite 'drop in' but the Canon cameras with quick load are fairly simple:

http://www.youtube.com/watch?v=LVTprc6x8MQ

This includes some of their olders SLRs and rangefinders like the Canonet QL line.

Some digital SLRs are about as simple.