I like the lower end spypoints. I have a BF-8 (~$150) and a a couple 2-N-1s (~100). They haven't failed me yet and have decent trigger speed and range for $100 cameras. Usually you can find the 2-n-1 on sale for even cheaper.
Covert MP6 is a very good camera. I have one that has taken over 300,000 pics and is still going strong. http://www.wingsupply.com/hunting-accessories/game-cameras/dlc-covert-mp-e6-ir-game-cam-6-mp-black/ This was one of the first pics I ever got with it. (My All Time Favorite Trailcam pic too!)
You can't beat a Browning Strike Force HD, in my opinion for the money and quality of both day and night pictures...Fantastic camera... Creeks!
Might as well ask which chain makes and delivers the best pizza. Might get a less diverse answer base