Hi all. I need to set up an outdoor CCTV camera and since there seem to be a hundred different brands and as many pitfalls I'm wondering if anyone here can help me navigate that minefield. I have zero experience.

I have the following basic requirements:

• Waterproof: It's outdoors, it will be rained on, plus there will often be high humidity, pollen and dust. It should not get fogged up. (IP66 or higher I think?) This also means there shouldn't be exposed plugs, otherwise it's not really waterproof.
• NOT battery powered. If there's a battery power option, battery degradation shouldn't prevent the camera from working, since otherwise that will massively impact longevity. I'm looking for something that can be wired directly to AC power.
• Wifi support: Comms cannot be wired in this installation. Norm will probably be n (2.4ghz) but ac+ should ideally be supported for future proofing.
• I probably can't buy it if it's not available in Europe (this often excludes some american startups).

With regard to what happens to the footage:

• I think IP streaming would be ideal?
• Abso-fucking-lutely no "cloud" based services. I have no interest in having to bounce footage through the US or china, or paying a monthly fee for unnecessary nonsense. I'm afraid of brands not being clear about this being a requirement before I spend my money.
• Some brands seem to have their own "server"/hub hardware? Why? No! I already own computers, so I don't need to waste money on a proprietary unitasker for talking to my camera.
• I think there are some open standards for camera streaming and open source software for handling the cameras. Support for these would be great. I'm accepting software recommendations too.
• I'm not in theory opposed to SD card support, but I'd rather not have to use local storage at all, and don't mind if it's not an option. If a setup requires storing in an SD card and then reading from it that's not the worst, I suppose (it's not that expensive to replace dead SD cards once every few years).

Optional bells and whistles:

• There is some illumination in the location at night, but some form of night vision would be highly desirable. Optional built in lights are probably also a good idea.
• Microphone is a nice plus.
• Motion detection and human tracking are a nice plus. The camera doesn't have to rotate 360 degrees; probably a ~60 degree angle of vision would be plenty. At the extreme, I'd say more than ~120 degrees is literally useless due to obstacles. (Obviously if an ideal solution has full rotation, I'll just take it.)
• Resolution+framerate (bitrate) can be as high as wireless-n can comfortably handle, but I don't really think I need more than 1080p.

Thanks in advance if anyone knows enough to be able to help.

My mom was interested in a smart doorbell to let her know what’s going on at the house when she’s not there, if a package gets dropped off or if someone tries to in. She does have a number of Google Pucks and an Android phone with some smart plugs set up with Google Home, but also has Roku TVs if that ecosystem is a major value add. I’m not super interested in yet another subscription service, but if it’s a “monthly fee to make the problem go away,” I can be convinced. Are there any must have recommendations or considerations I should keep in mind?

Edit: As far as I can tell, there’s no wire leads on or around the doorframe. The old setup had a chime wired to the wall of the foyer, but that was uninstalled and the wall was repaired, so I don’t think there’s a lead if that changes recommendations.

Had an interesting conversation with my colleagues this morning. We were pretty split whether phones listen to us for advertising or not.

On one hand, we anecdotally see Google news and ad suggestions based on what we say. We know our mics are on at all times for voice assistant and music detection. But we also read online talking about how there is no evidence about the phones recording us. It's hard to trust anything nowadays.