Like anything, if you want quality you are going to have to pay for it.
You can go for a commodity brand like those recommended on the sites linked above. You can be assured that most of them have backdoors or major vulnerabilities and are grossly over priced for what you are getting.
*or*
You can go for actual, real CCTV cameras which are designed by companies that sell security equipment rather than cheap [censored] home networking gear. Better imagers, better lenses and far better security.
Axis is the only recommendation so far in this thread I'd even give a second look. I'd also recommend investigating Panasonic, Bosch, Pelco & Samsung. If you want cheap Chinese then Hikvision is probably worth looking at, but as always you get what you pay for. I have some Hikvision cameras at home alongside my real cameras. They were 25% of the cost of some of my Bosch and Panasonic cameras and still are not worth what I paid for them, but hey if you are going to make recommendations it's best to do it from the perspective of having tested them yourself.
If you plan on exposing anything outside your network and particularly into the "cloud" then after I stop laughing at you I'll steer you away from any product produced by a networking or PC equipment vendor. They have no idea about security.
If you think I'm being condescending, it's because I spend a good proportion of my life trying to explain to people why their footage is of no use to police, why people on the internet can watch their kids playing naked in the back yard and how the imagery of them doing naughty things made it out from the nanny cam into the outside world.
A CCTV camera is a powerful tool and the footage it captures can have serious ramifications. If you want to set up CCTV at home, have a serious think about what it means. Failing that, just know that you are trading any privacy you think you might have for the convenience of being able to access the cameras from your iPad.
(edit) But hey, this is the internet and BITOG where people pretend to be experts about all sorts of stuff they looked up on Google, so you might just ignore me and do it anyway