Those are not worth returning or repairing. Just replace it. If you want to try a repair, I'd suggest /r/diyelectronics or similar, but it will cost way more to fix than a quality new camera most certainly.
I like ReoLink cameras for home use.
No matter what you choose, be aware of security implications for connecting cameras on any trusted network. Always isolate them.
$1k wouldn't get me started for the electrical runs and cabinets for the hardware.
We are not talking about high voltage telephone equipment.
The switches in telcos are totally different than low voltage Ethernet with sensitive transcivers.
Grounding differential potential between structures, even just a few feet apart, is often enough to destroy Ethernet transceivers without lightning strikes or surges.
Notice: I've been in IT and telco for over 30 years. I have worked on Nokia telco switching equipment and can 100% tell you that Ethernet transceivers will absolutely be destroyed with much less effort than telco.
This is why it's important to have other security monitoring resources on your network if you intend to open ports or expose your services to the Internet. Also a good time to change all your passwords if you have not already.
Attaching to light poles you dont own or have permission to do is a crime in most places.
If you do have authority to do this somehow, I would use a power tap on the street light photovoltaic sensor. They are a twist lock style connector. They sell pass through options to keep the original sensor. That's for the power.
As for the connectivity.. If you have permission to do this, you likely have permission to install a omnidirectional WiFi ptmp station and wireless clients (directional) at each camera. Otherwise, just use LTE or fiber. Most municipalities run conduits between each lamp and there may be existing access for fiber. You could also microtrech fiber (since you presumably have permission).
I've done this for municipalities. It's pretty easy since everything is already in place- which is why I question your intentions here. Anyone who has permission to do this would probably not need to ask how to do it.
If you cannot use fiber, which is the obvious solution, I'd recommend a wireless solution.
Grounding is not going to fix this issue.
OP: 24 people telling you CCA is garbage. Now 25. Do you need any more or can we put this one to bed again?
Is there a reason you cannot accomplish this with a selfhosted VPN?
Exposing anything has risk. Risk of loss of data, your systems being used for other attacks, and loss of time/money to fix. It is entirety possible to do this as safe as practical of course- keeping your stuff up to date and having some kind of visibility into intrusion detection for immediate response are ways to minimize issues.
Interesting. I've been in IT for over 30 years and have always used UPS systems. Never had data loss as a result of power issues. Also, it cleans the power a bit and I get a lot of life from my hardware. Plus, I dont have to worry at all, it works as intended. My entire lab has redundant UPS systems backed by a large generator ... Zero downtime is nice.
I think it comes down to how reliable or fast your internet is. You can selfhost a lot of stuff with reliable internet, power, and environmental variables.
If you have any of those which are less than reliable, a VPS like Linode may make sense for uptime.
My UPS systems have built in monitoring.
The reolink cameras dont have popups and not even sure about cloud services, although I have not really looked into them. I have over 20 at my house and just record locally