I would highly recommend the Moultrie Game Spy 4.0. Yes, its a Moultrie and most folks hate them (I too wasted $99 on a Moultrie 100 that wouldn't trigger if an elephant walked in front of it). But these cams work pretty darn well. I own 2 of them, and for $89 at Academy, you just can't beat them. The trigger is fast, and although they take 6 D batteries, they last forever. To see the quality, check out my post in the picture forum. A 1 gig card will let you get around 500 pictures on this camera set at high quality.
By the way, I also own a homebrew made by Outdoor Bob. If money is not an issue, buy his - they are awesome. You won't regret it. But if you're just getting started, you might want to try a cheaper one first.