I think what you need depends on a lot of different things. Is it going to be a trail cam or a feeder cam? If it is a trial cam you need a camera with a fast trigger time. If it is a feeder cam you can get away with a less expensive camera with a slower trigger.
Is theft a problem where you will be putting your camera? If so, then size, security box availability and a security code function might be important.
Personally, I have never had luck with <$150 cameras. I have a moultrie I-60 and a Scout Guard that I have been very happy with.