This is probably an outdated view, but I remember at one poibt that a good password is to be easy to remember and hard to guess.

However with the ever prevalent password cracking passwords have been pushed further and further into obscurity. With a difficult to remember character requirements making it difficult for the average user to remember their passwords. (Worked with enough family and enough “forgotten passwords”)

To prevent passwords from being forgotten most people write them down. But thats a bad idea, thus Password Managers. But they both reinforce the notion of making passwords hard for people to remember, with being more convient for the user, while at the same time potentially being worse then a sticky note. Since all passwords are in one place secured by one password (lastpass).

A website host or service provider needs to be the ones vigilent for this, not the user. The tools like salted passwords, 2fa and keeping their data and databases secured. And honestly for personal use, a note book of passwords is alot more secured since you need physical access to the book and your machine as well as knowledge that this books exists to get your passwords.