Lots of options with widely varying levels of cost and features.
I went cheap with Wyze cams, but they do what I need, were very low cost, and I’m not paying any subscription fees. They allow live streaming through their app, have free 7 day cloud storage of 12 second motion triggered clips, allow continuous (or motion triggered) local recording to a micro SD card, have two way audio, and night vision with IR lights. They also have notification capability for motion or for person detection, and take you straight to the 12 second clip when you click on the notifications. They can also listen for smoke alarms and CO alarms and notify you if one goes off. On the less positive side the audio quality isn’t great, there’s a 5 min cool down period between motion events for the cloud clips and corresponding notifications, and navigating the recordings on the SD card is a bit cumbersome. But they’re only $25 and there’s no subscription. They are powered by a USB cable.
I have a family member with Nest cams, and upon comparison they seem pretty similar to me, but have slightly smoother video (same resolution but higher frame rate), and they pay $5/month to get 5 days rolling cloud storage (I think they offer only 2 or 3 hours cloud storage for free).
Other popular options seem to be Arlo Pro, and Ring.
Hopefully others will chime in with their experiences with more full featured options soon.