I can't tell you the best but I can tell you what I have and post a few photos so you can see what you think.
I have a 2012 model Bushnell, the model number ends 437C. With Bushnell the model number is important as they have all got basically the same name and they all look pretty much the same but there are big differences between each year's model.
The reason I wanted a 2012 model was that it had a very fast trigger speed. Some cameras are pretty slow and so miss a lot of shots where the deer walks across the front but is out of frame before the camera has time to fire. I was also not dead keen on spending a lot of cash for something I was going to leave up a tree and I got the Bushnell in the USA for £112. Mine is the smaller sized camera with the "low glow" flash as I'd prefer something smaller rather than bigger. Bushnell also make a bigger size that takes 12 AA batteries, their "black flash" ones tend to be in the bigger sizes. Bushnell get a good reputation for their sensor and I have had no false triggers that I can tell. They also get a good reputation for battery life and mine was out every day since August and still working fine so last week I put it into time lapse mode and set it to take a picture every minute. I left it doing that for 6 days, 8651 photos, and when I came back it was still working and showing a full 4 bars on the battery indicator.
On the down sides - Trail cameras are outside in all weathers and are relatively "cheap" bits of gear so they are prone to failure. I'm sure there are people who have used the same one for years etc. but reading the US trail camera forums (where they take this stuff pretty seriously) it seems to me that the average life is between one and two years. You might get lucky and do better but I'd say any more than that and you are ahead of the game. Also the camera sensor actually needs to be aimed quite accurately at the area in which you want to detect deer otherwise it is either "shooting" into the ground or over their heads, this is something it took me a while to catch on to. The sensor is also only good out to about 40 feet which isn't very far if you decide you want the camera to cover a whole forest clearing. The flash range on my Bushnell is about 60 feet which is considered very good for trail cameras, a lot of the black flash cameras seem to struggle to do 20 feet.
There are new Bushell models for 2013 and I'm considering a black flash one this year once the prices start to come down a little. I am confident that the "low glow" flash is seen by deer if they look directly at the camera and that they do run when they see it (I take 3 picture bursts and so have photos of them looking at the camera and then running all taken within 2 seconds). I also have a feeling that once they've seen it, even if they don't run, they start to avoid the camera - I often get lots of photos for 4 or 5 days and then they tail off to nothing. I believe the new 2013 Bushnell black flash (576C is the model number I think) cameras claim a flash range out to 60 feet, plus a sensing range to 60 feet as well and I think black flash, now the price is coming down, is probably worth having if it isn't going to reduce the flash range to next to nothing.
Anyhow, I will post some photos and comments for you to see what I'm getting and consider if it might suit your aims:
One of the recent timelapse photos with a deer in it. That deer is out beyond 50 feet and didn't trigger the sensor but was captured by the timelapse, the camera was up high and tilted down which would have reduced the detection range significantly:
Demonstrating the fast trigger. As you can see by the motion blur I was walking very quickly. Also note that motion blur can be a problem as the cameras use relatively long shutter speeds to get max flash range and produce images in low light:
A nice daytime shot showing the sort of quality you can get, note that the deer is very close to the camera and that to get good photos you really do need to be in close:
This deer was looking right at the camera when the flash fired. This is the first photo of a 3 shot sequence and I will post the 2nd photo below it. I think the message is pretty clear - they can easily see the low glow flash and it does spook them. Note the time difference between the photos and also the motion blur when she runs: