I think this only makes sense as True or False/None ( going back to your original way I think)
as there is no difference between any and all, so might as well make it True by default (to synchronize)

though I am going to make an option on an individual table to be able to write an all nan row (maybe by setting dropna=False, default will still be True)
so that may be confusing