> note: I also have no smart doorbells, cloud connected security cameras, ...

If you want a CCTV camera you can still get 'old school' commercial grade IP cameras from eBay. Mercifully free of cloud attachment, but with ftp, email and http notification. Probably will have dynamic DNS, but that can be useful.