please keep in mind I don't want the big professional cameras or the little flip cameras here is the kind i want http://www.amazon.com/dp/B0031RGL0C/?tag=bestprice003-
For After Effects exclusively or will you be using Premiere?
I would look for a camera that shoots to h264 video .mov/.mp4./m4v files. I would tend to avoid AVC HD cameras as the footage isn't directly viewable and it's a mess of folders and metadata to backup. I do believe Premiere can transcode AVC HD in realtime.\