I have a Stealth Cam that sucks. It would make a better boat anchor than a trail camera.
I have a Cuddeback Excite that's pretty decent. One problem when I first got it was fixed by Cuddeback free of charge and it's been working good since. Photo quality isn't that great. Lot of dark photos and blurred photos. Sensor seems pretty good, trigger speed is good, and battery life is decent. Overall, I would recommend it as a decent middle of the road camera.
I also have a digital CamTrakker that hands down has the best sensor, the best image quality, and the best battery life. It was also the most expensive and has a few issues of it's own. Namely a problem with making sure the camera is exactly aligned within the housing otherwise when the lens opens to take a photo, it won't.
The one thing I've found with trail cameras is that you get what you pay for. Check out our Trail Cam forum for more info.
http://www.huntingnet.com/forum/tt.aspx?forumid=104