There are two styles of pressure switches.
The one you want has a lever on the side that prevents the pump to re start if the pressure is very low as would be the case of a burst pipe.
Say the switch is set for 40/60 but a pipe bursts and pressure dropped to say 20. The contacts would not close and the pump would not run.
The 'safety' type is a mere few dollars more than the conventional version.
To re start the pump you have to manually hold the lever to close the points until the pressure builds up to the threshold.
You see it on the pressure gauge as well as feel the the lever sort of go limp when pressure passes the threshold.
We are in cottage country and I only installed the safety style as owners are generally away lots of the time and more than a few times pipes have frozen causing major messes.
Withe the levered safety version the worst spillage you could get would be one cycle worth of water (like maybe 10 gallons or so depending on tank size)
link?
They also protect your pump from burning up if the well goes dry.
There are variable frequency drives custom built for well pumps as "constant pressure". Iirc some will sense high flow and low pressure from a pipe break and shut down.
Looks like it would work, I'm leaning toward a DiversiTech WS-1 Wet Switch Flood Detector, 24volt transformer, and a relay wired up to the pump stair switch.I think you could use the Water Cop for that. Just connect it to a relay that cuts power to the pressure switch instead of connecting it to an electric valve.