I'm all for strong passwords, but a couple problems:
1) Some websites use ridiculous restrictions that actually make it harder to make a secure password (i.e. has to be exactly 8 characters, no special characters, no spaces, no punctuation, etc.).
2) As has been pointed out numerous times already, expecting people to keep unique, strong passwords for 10, 20, 30, however many different sites they use is simply unrealistic. I myself reuse 3 or 4 relatively low-strength passwords for forums and other things where getting the account breached isn't really a huge concern. For any financial website (e.g. banking), I will take the time to create and remember a complex, unique password (although there are a couple financial websites I use where I CAN'T make a good password because of the aforementioned dumbass restrictions).
All websites need to move to passphrases (e.g. "See spot run to the bathroom.") rather than passwords. Passphrases are both easy to remember and more secure than even a strong, complex password. Of course, you can't do anything about the idiots that use things like their kids' names and other things that are easy to guess no matter what you do.
As for things like Keypass, I don't feel that having all my passwords recorded in one place that somebody could conceivably breach is terribly secure. Might as well write all my passwords down on a piece of paper and toss it in my desk drawer.