I ended up ordering a
Linksys WVC80N from newegg.
I have to say, this camera completely surpassed my expectations. Low light viewing is very good, it emails me when motion is detected, and I was able to setup a "zone" where the camera would look for motion. Set the zone up high enough so the cat walking around wouldn't set it off, but someone opening the door would.
I decided against the alarm clock spy cam type deals, because they didn't really have many features that I needed, and this cam fit a lot better.
I also found an android app for viewing cameras, and this one can stream video. I can view the camera on my cellphone from anywhere, and that's just fucking awesome.
Overall I'm really impressed with it
