I need a camera that deals with low light situations, various people using the camera and some who move it. I need a camera that has the ability to forgive many nonprofessional photographing tendencies. What should I look for? My budget is limited ($500).
OK... so as others have said, it really is a topic that changes, but I'll try to write up an answer that is general enough to last a few years - or at least months.
A compact camera "system" that is accessible to non-professionals and professionals alike to photograph under a variety of conditions, including amongst them bad light.
1) Entry level compact.
2) Mid level compact.
3) High end compact.
4) Micro 4/3
Excluded as not compact:
5) SLR camera systems
This leaves two remaining classes of cameras to consider:
3) The high end compact camera.
4) The micro four thirds system.
As other posters have pointed out, exact model names change frequently, hence it is important that the aspiring buyer investigated the current offerings in the listed segment. This can be done using many review sites, of which one is found at: http://www.dpreview.com/
More specifics would help understand your requirements better, but I'll take a stab anyway. Low light conditions would require a camera with a large sensor, which takes you into DSLR/MILC territory.
Based on the specified price and ability to shoot in low light conditions, I would recommend the following models:
However, please remember that ILCs like DSLRs and MILCs require more proficiency to get good results than compact cameras. So, there may be a problem with the forgiving "non-professional photographing tendencies" part.
I would suggest you go to a store and get a feel of both these cameras before making any decision.