Dlink DCS-932L
First of all, thanks to all those who have contributed to this thread, and especially to Dr Archer for starting it, there's a lot of good information here.
I wanted infrared or nightvision capability, so I got the SMC camera. But for the life of me, I could not get pictures transmitted over the internet (I have an Asus RT-N56U) ... even after setting up port forwarding, dynamic DNS, etc.
At the last IT show, I bought a Dlink DCS-932L ($129 show price, a veritable bargain IMHO), and let me tell you, the setup's a breeze! I'm not aware of the risk going through the "cloud" (i.e. through a Dlink server), but with the myDlink Lite app, I was up and going in minutes.
I'm still going to try to get the SMC to work, but for newbies and those who just can't be bothered fiddling with settings, etc, this is a wonderful, painless entry into the word of IP cameras.
I'm going to get a DCS-5230L to play with next, it's also "myDlink" cloud-capable.