Before I discovered password managers, my brain and poor memory was a single point of failure. Moreover, I just used the same password everywhere with a different but predictable suffix. I would not recommend anyone do this.
Password managers are great. I use Bitwarden on their hosted version, but you can self-host as well. Just make backups, commit to remembering a strong master password, add two-factor authentication with physical keys, and you'll be fine.