I have had no issues with my Nest. Google Home integration works great. Still looking for camera suggestions.
A few years ago, I installed Nest Cam (back when they were DropCam before Nest bought them) cameras in our office where I used to work after an attempted break-in and they worked great.
Those cameras do not store videos locally though. You can use them as live stream cameras without a subscription, but if you want the videos stored, you'll have to subscribe to their cloud-based video storage service, which was quite reasonably priced to me. I think they store videos on that service up to 10 days, but they may offer longer options. You could re-watch, pause, etc. the videos going back 10 days through their service from any of your cameras.
I installed 5 of them and signed up for their subscription service and, while they did use a lot of bandwidth uploading the video streams to DropCam/Nest servers, it was great to have the videos stored off-site and remotely viewable without the bottleneck of the WiFi network's upload cap and without fear someone could disconnect the cameras and/or take out the sim cards (like other camera brands rely on) and lose all of the videos.
The cameras were good back then (720p then, I think they're 1080p now) with night-mode for low lighting. They offered motion detection and even provided the ability to create watch areas within the video to monitor which helped us prevent false alerts due to headlights in the parking lot after hours, sun rising/setting, etc. They had apps and web access plus the ability to speak through the cameras if necessary. You could watch one or up to 4 (back then) camera streams on one screen if you wanted. When activity was detected, the service would automatically contact us based on configuration to let us know.
The owner lived around an hour from the office so it really helped her when the office alarm system triggered (quite common due to being located right next to woods) to not have to drive all the way to the office in the middle of the night because a wild animal triggered an alarm while roaming on the back deck. She was really excited to be able to talk (or yell) at any person who might break in through the speaker system. I would think it would also work well as pet, baby, etc. monitors, though I have no experience using them for those things.
With the subscription service you could set schedules for them to automatically turn on and off so you didn't waste bandwidth or record yourself and/or others while you were there. Though we didn't use it, the service also offered an automatic detection system for your phone so when you walked in with your phone, it stopped recording.
I am not sure if all of these features are still available or if they had added more because it has been a few years since I worked with them, but you might want to at least look at them, especially given you have a Nest thermostat.
I plan to install cameras at my house soon, so I'll be looking at various popular options, but I admit that I am probably going with the Nest Cam cameras and video storage subscription service unless I find something that really impresses me.
