The Bushnell Trophy Cam is the best trail camera for the money - period. I've tried cheaper ones and they always end up having major problems.
I'll put it this way - I've got 10 Bushnell Trophy Cams, and I don't have that many because they suck.
I've only had issues with 2 or 3 of them, but that's years of exposure to the elements and exhaustive use (thousands of pictures). And all I need to do send them to Bushnell and they'll repair them as good as new.
This year I bought a couple of the "basic" 8MP Trophy Cams from B&H Photo (online) for $139 - free shipping. The price goes up for the HD, black flash, etc. versions.

If you want absolute perfection and flawless performance, you'll have to shell out $550 for a Reconyx. Make no mistake, I'd love to have a Reconyx but unfortunately I ain't rollin' in Benjamins.

I've been extremely satisfied with my Bushnell Trophy Cams. I doubt you'll find a better camera anywhere close to that price.

*FYI: Don't get the Bushnells cameras they sell at Walmart - they aren't the same. Only get the models in the "Bushnell Trophy Cam" line. I haven't been able to find them in any local stores, but maybe that's b/c I live in the boondocks.

Good Luck!