The TP-Link Tapo cameras I have are wireless and seem to work well enough. I'd recommend to run them through frigate or some other independent surveillance software if you don't want them internet accessible.

They're quite cheap when they're on special, and Amazon seem to have specials on them relatively regularly.

(as much as I don't like to recommend Amazon for anything)