I'd start by thinking through what you want to accomplish -- do you need a camera at eye level to capture the face of people who come to your front door, a wide-angle weatherproof unit to capture the entire driveway, or maybe one of each?
I am not a fan of anything that will stop working when the cloud service is down or unreachable, so I use a local network video recorder (NVR). Most NVRs can record locally to a hard drive or flash, and optionally allow remote access, and/or upload a notification and snapshot/video when motion is detected. If you are really ambitious and have plenty of free time, you can build your own NVR with commercial or open source software.
Personally I look for wired IP cameras and DVRs which state "ONVIF Profile S" compliance, this gives some assurance that a camera or DVR will be compatible with other brands, avoiding vendor lock-in and having to replace everything when the manufacturer goes out of business. For example, looking at Netgear's history of dropping support for cloud-dependent products,
I am dubious about Netgear's Arlo.
While most cameras can be powered by a 12VDC plug-in adapter, I prefer power-over-ethernet (PoE, one cable for power and data), specifically 802.3af or 802.3at (not proprietary "simplified" cabling). I like PoE because I can connect the switch and recorder to a battery backup, all the cameras stay live and recording even if power is out, and I can expand my system with any PoE-supplying Ethernet switch.
For motion detection, cameras which also have a PIR sensor (usually a white faceted dome on the front of the unit) generally have fewer false alarms than ones which only use image processing to detect motion.