If you want a local camera system you need a NVR (Networked Video Recorder). These have Ethernet ports and’s you connect security cameras to them over Ethernet, they record, store and allow you to view the footage.
A DVR does the same thing but will use a video signal to record, maybe coax or component. These are getting a bit old and also have lower limits on how far the video signal can travel than an NVR but work and are cheaper, many offer network access to view the cameras and recordings.
If you are looking at budget options you can use the software FrigateNVR. It is an open source NVR software designed to work with any camera that uses standard protocols (and many that don’t thanks to the active community). Including wireless cameras although everyone in the community recommends avoiding wireless cameras unless have no other options.
You will be able to use your wyze cameras will frigate.
Almost all IP Cameras, especially the cheap one are considered compromised and open to easy hacking. It is important to isolate them on their own VLAN, if you really care about privacy so they can only talk to your NVR.
It is important to remember security cameras are cameras and need light to perform, especially in the dark. If you need a camera to perform in no light situations you either rely on its own lights which will illuminate maybe 5-10m, and external light source like a flood light or you have a larger camera sensor that can drink in the ambient light for decent quality (this last option will only come from a camera that costs 200-300USD.
A cheap 4k (8mp) camera will perform worse in low light than a cheap 6mp as they often have the same size sensor.