Blender booleans have always been extremely finicky especially when input meshes have wonky normals or they aren't water tight. I feel competent with preparing mesh inputs properly yet booleans remain unpredictable. Usually I can get something working by decimating/remeshing, exporting, re-import, etc.
But with this particular file (attached), none of my typical bribes successfully get the boolean to function correctly. If you open the file you'll see the "Cube" object in local mode with a boolean modifier urging the "Sphere" object to subtract its volume from Cube.
Is it safe to say booleans aren't "quirky" as much as they are "buggy"?