Ive never used any. There are different styles, some have a little flap, some have a little ball. If I'm not mistaken the swinging flap style offers more resistance. But I'm not sure.
As they get old and accumulate detritus and algae they are less effective. This is more of a concern for saltwater.
I've always either utilized a siphon break drilled into the return plumbing or positioned the return where it was high enough up that it couldn't back drain much water, and if it did, the sump could accommodate it.
Imo relying on a check valve to prevent a flood is almost as dangerous as not utilizing one in the first place. Design the plumbing so its failsafe.
Sent from my SCH-R950 using MonsterAquariaNetwork App