I don't know how many accounts an average internet user has, but I'm pretty sure it's well above the human's memory capabilities. Assuming this is true, there are 4 scenarios:

You use the same password everywhere, so any service leaking it means it's leaked for every other one.
You use different passwords every time, so you have to have a centralized vulnerability where you store them all.
You memorize some, and the rest do the same as 2.
Like 1. Except you memorize more than 1 password.
Is the least secure but the easiest.
Has the centralized vulnerability problem.

Assuming that in 3. You don't store the most critical passwords (email, banking, etc.) it's the most secure. But requires a lot of care and memory. And also has the highest penalty if you forget a password.

Is just 3. But worse (but don't need to check the password storage).

So instead of comparing 2. To 5. (5. Being a magical scenario where you can remember all your passwords that are different from each other). We should compare 2. to 3. (Or 4. Instead of 3. If you really don't want a password storage).

Is massively more convenient than 3. The only advantage of 3. In convenience is that you don't need to have a password storage for some passwords. Which I don't think it's comparable to having to remember passwords.

The only security benefit of 3. Over 2. Is that your critical accounts are safe if that password storage is breached.

How likely is it to be breached though? If you are serious about security you should be using an actual password manager, which is focused on security. The only way to get passwords out of it should be to put in the master password, which should be impossible if the master password is good enough (which you can afford since you only need to remember one password). Additionally, you can use multiple factors, which might not be available on normal websites.

The only moment really where a password can be intercepted is while it is in your clipboard. Which is why TikTok reading the user's clipboard without consent should be taken way more seriously than it had been.

Of course every method fails with the wrench to the head technique (insert xkcd here).