I don't have much to add as the others have given some great advice on seeking reviews on different models, but from personal experience I have a Moultrie M-80 XT and a Bushnell 8MP Trophy cam, both bought last year.
They were both around $125 (online) and both take great stills and videos but I'd take a second Moultrie M-80 over the Bushnell for these simple reasons:
Better latch desing
Better strap design - The Bushnell strap is a PITA, IMO
IMO a better battery compartment (both take 8 AA's)
Can be set up to take still AND video (Bushnell is one or the other)
Not owning a trail-cam before, I didn't know what to look for, but as trivial as those items may seem, the first 3 I listed are a lot more important than I thought they'd be. Both also seem to be equal on battery life and they've both taken several stills and videos without the Game being spooked. They're hearing something because I have many shots of deer coming right up to the camera, like this one did, but apparently not enough to scare them away. I even have a great video of a deer licking or "nosing" the cam, but here's one of the stills:
