I said I’ll do it, but I finally did: macOS Sequoia. My main concern is dealing with the permissions (as described here among other places).
I ran and upgraded Homebrew and its various packages with no issues. Emacs however seemed to have “forgotten” how to access the Desktop. Looking into this.