Check valves and drilled holes are both a false sense of security and totally unnecessary, they will fail even when maintained and usually at the worts possible time.
Keep your return under the water but close to the surface so only a vey small, very easily calculated amount of water flows back to the sump in a power outage and can easily be contained as long as you keep a couple inches of freeboard or spare room in your sump.
Once the level drops 1/2" or whereever you set your return it is exposed to atmosphere and the siphon breaks. You now have the best an simplest backflow prevention device known to man, an air gap. We al know water cannot jump uphill so it cannot flood, is not mechanical so needs no maintenance or cleaning and you can sleep soundly at night with no fears.
Using my systenm as an example, it holds 100 gallons and my returns are 3/4" below the surface. When the power goes off it flows a maximum of 3.4 gallons to my sump before the siphon breaks. I have a 30G sump and its is 2/3 full as that is where the skimmer works best so I have 10 gallons or freeboard at all times. I never worry about a flood and I don't have to clean any check valves or drilled holes and have no annoying water jetting out of a hole. If you think about it, a grain of sand, flake of food or algae can defeat the check valve, it does not have to be a catastrophic failure, even a trickle will flood in time if you don't catch it. Drilled holes can be covered by a snail, anemone. fish, food, algae or whatever and even if I cleaned it 10 minutes ago there is no guarante the power does not go off and suck that small fish up against it.
Design the return correctly from the beginning and floods are a non issue.