Isn't this just a roundabout way of saying that you can remove files from a directory you have write access to? What's the relevance here?
My mental model is that a directory is just a special file that links to other files.
Adding or deleting a file to a directory is just a case of writing to the "special file" to add or remove links to other files.
Any other hardlinks in any other directories are completely unaffected.
"I assume that SQL tables are basically just fancy CSV files. Therefore strong invariants are obviously confusing."
But some people don't know, and benefit from learning it. So chill.
The point of chmod 000 was to say that clearly nobody has any any permissions to do anything directly on the file; that the permissions on the file must have nothing to do with it.