Opened up a can of worms, didn't ya?
MY preference is the ScoutGuard 550. I've used a number of different cameras over the years and have several of the SG's. Small, great battery life, loads of clear pictures and video, easy to set up.
For night shots, be mindful of aiming properly and distance. Other than that, no problems at all.
Good luck with whatever one you go with and Great Hunting!