Using ArcPro 2.9 I can Define and Build Overviews using all the default settings successfully (output is TIF overviews), but trying the same in a script using Arcpy with the default ArcPro environment the TIF overviews are consistently blank no matter what I try. That is, the actual TIF files themselves are mostly empty (only a few kilobytes each) and although they are in the mosaic dataset table, they do not draw at all.
Is this a known bug? Even when copying the python output from ArcPro it will not work in a standalone script.