Probably not related but after moving to M2 Max MB Pro, Time Machine backup to my NAS fails when the screen is locked. Error message says something like TM can’t access some files. This backup worked fine on my 15” MB pro
Time Machine backups have nothing to do with iCloud. They would even work with the internet disabled.