Anyways, it depends on the app you use. Some Keepass apps haven't even been audited for example, so security of those apps may be questionable.
How would you remember a password of 128bit of entropy?
Also see: https://xkcd.com/936/