A RPi option is likely your best bet. I’m currently building my own setup using MotionEye and a few Pi Zeros. I’ll be looking into different software since Motioneye is no longer updated though. Just FYI, I’d avoid the v3 camera module for now, as a lot of software doesn’t support it yet and it can’t use the legacy camera stack.
Same here, but I’ve also set up a Pi Zero W to run pihole/unbound at the inlaws place without any issue.