@davew I’ve written about my too long battle with this here.
Hope some or any of this is helpful. FYI I had the same issues yesterday and the Messages solution is what got things back on track.
https://warnercrocker.com/2023/10/05/time-for-apple-to-come-clean-about-icloud/