Take a look at the Fujifilm S1500.
It has the usual automatic modes and also the important manual controls.
You can find it for below $200.
Here is a link to a full review of the S1500:
I am trying to find any information on a good inexpensive digitial that would work for taking photo's at fire investigations. It will need a good macro. Also - should be at least 8 + meg. We have used point and shoots in the past and want to get something a little better. Unfortunately we can not afford a DSLR, but maybe a megazoom ?? Would like to keep it under $ 300.