I just found this today and it seems to work pretty good. Give it a try and post some results.
[link=http://www.planetgamecam.com]Planet Game Cam[/link]

This is the small test I recorded today. I used windows movie maker to convert to windows media. The AVI file that it creates is too big.
[link=http://media.putfile.com/AFPD-and-GAME-CAM-LITE]AFPD and Game Cam Lite[/link]
After I tested the demo version I purchased it. The demo has the audio recording disabled. For $10, it's not bad at all.