Just an update on my situation... We decided to go with the Ring doorbell for our needs. We're hoping to catch on video any entry into the house, and also the driveway. We'll be putting an additional doorbell downstairs too, covering the basement entry. Their cloud setup is only $3/month per device, so that will be an additional charge. After reading the reviews on Ring, it should hopefully work as advertised, and people do seem generally happy with it.
And if I can see one of those Yi 1080 resolution indoor cameras below $50 mentioned earlier, I'd probably complement my setup with one of those inside.
Thanks everyone for the suggestions... after spending a lot of time researching, there really were some excellent recommendations made on this thread - Yi (or similar low budget inside camera), Arlo, Ring, and Nest are all outstanding choices, depending on your needs and budget.