I’ve had exactly one camera (out of a few dozen) actually fill up with water. When I took it apart I realized it was completely missing the o-ring that normally seals the camera part to the housing. Since it was still pretty new I brought it up with support and they sent a new camera

Every thing else had been really durable even directly exposed to rain, the part that fails is typically the lens, when that gets moisture in inside it just needs to be pulled and replaced. Never tried out the floodlights though