If you're using a development framework to interact with data (Rails, Django, Express, whatever), you've most likely had to make smart choices on how cascading deletes work in your system. & often in large systems, you're forced to make a compromise.