Definitely, the Pi Zero W is now my go-to controller for almost anything that needs one. The fact that Microcenter frequently sells them for $5 seals it.
I pair them with a $15 aMLC (MLC in SLC mode) industrial MicroSD card[1], and they've been rock solid, no FS corruption on power loss, no Wi-Fi drop outs.
The ability to add the Pi Camera board and have a tiny full HD networked camera with trustworthy "firmware" is a killer feature though, pre-made IP cameras at any price tend to have outdated insecure or even malicious firmware that may or may not be replaceable.
[1] https://www.digikey.com/product-detail/en/atp-electronics-in...