No you are right. There is no way that wifi will be more reliable than hardwire. But it can be just as reliable. I However am doing better than a constant ping. I am recording 24x7 on my NAS for 3 years with a notification whenever a camera gets disconnected either by dropped frames which are much more demanding than a ping. 100% of my failures are from POE cameras which have very long cable (cat7) runs even now than my setup issues are resolved and are very rare.
The wired hardware are limited to 100mbps while wifi real bandwidth varies greatly and can be unstable, it can be setup to be much higher (700-800mbps) than hardwire so that in case of instability it is still far enough to cary the 10-30mbps stream. That's why I mentioned 5GHz. I don't know what wifi you used to be this absolutely certain that it will fail but I can tell you, wifi can be setup to be stable enough. I am currently recording my wifi doorbell RTSP stream 24x7 as well with 0 dropped frames for the past 3 days. I have had a couple of drops out of my 10 hardwire cameras in my log during this same time span. I had catastrophic connectivity with constant drops when I was on 2.4GHz which was prone to interferences and had limited bandwidth. I used an RF spectrum scanner to find out how much the wifi RF band was saturated by the video stream and it was a disaster which is what prompted me to move them all to 5GHz.
If you have one of these gen2 apple TVs you may notice in their case that wifi streaming is higher resolution and more stable than hardwire. It is all dependent on the setup: the ethernet on these devices only support 100mbps while wifi was on 5GHz 802.11ac running at >250mbps actual net bandwidth (433mbps*60%). I will always prefer hardwire over wifi but saying wifi will fail for certain... is just not true, at least not anymore. It all depends on how you set it up and the environment you are in.
Wifi can NEVER be just as reliable as hardwired. You are a novice and simply dont get it. That is obvious from your use of
amcrest wifi cameras. I dont believe for one second that you NEVER dropped a frame in 3 years. That is IMPOSSIBLE. Your system is not properly notifying you.
You also dont seem to understand basic concepts of switch and wifi. While they camera itself is 100, a gigabit switch can handle a gigabit load.
IF you are having issues with wired connections its because you are using cheap cable, improper
crimping, poor hardware or a combo of the above. While 5ghz can suffer less interference, it is simply not good enough for an always streaming device like a camera.
Wifi is proven unstable and should never be used for critical surveillance.
I dont have nor will i ever have anything made by apple.
Its cute how much trouble folks go through to get barely usable wifi with multiple access points, simply because they dont have the skill to run cable and refuse to pay someone to run it despite it being cheaper in the long run than wifi.