My kids sometimes use a Canon EOS300 35mm SLR (the film version - no D at the end). You can put it into "green mode" which makes it point and shoot - but if I want to use the camera then manual mode, aperture priority, and shutter priority are all available.

I paid 5 for the body and used existing prime lenses.

The children call it the "awesome camera" because in comparison with digital compacts, you can actually see what your composition on a sunny day.