I have the same “issue” as you - an unexpected Backup not completed - it started after an OS update - maybe original Sequoia but I think an update after that - I bought my hard drive last year so it’s new (LaCIE) so I think it’s an Apple thing. It’s my Time Machine for my MacBook Air M2 15" so it seems to happen after it’s reconnected after a stint of laptop use.