Password managers are an odd one for me. Almost a solution looking for a problem, and having a massive problem of their own -- all your eggs in one basket in the way most people use them, and the people that make them intend you to use them. That is not just keys to the kingdom but keys and a removal crew to help you pack. Even without that it is almost false security, especially the way I see them sold.
I certainly don't consider them an essential part of security and would not look down upon someone not having one, not in the slightest. As far as I am concerned the best security feature is that by default you will probably have long random passwords, and can set alarms to force changes, the former of which is solved by
https://xkcd.com/936/ and the latter by everything from a diary on upwards.
It also depends on your use scenarios* and what efforts you want to take, possibly also how good you are with computers (and if you are geeky enough to have that joke in your signature then it is a fairly decent bet that you don't lack capabilities). Depending upon how you are playing that then it changes a lot.
*floating between 10 different PCs is different to just one PC to just one PC and a phone/tablet is different to needing to share login credentials for your business/group twitter account (last I checked Twitter had not managed that, facebook had though, in any case for a basic business account you use as an advertising feed then there are all in one solutions for all social meejas which do far better)). If it is just one PC then browsers offer to memorise passwords for you, you should be wary of
http://www.nirsoft.net/utils/index.html#password_utils but that is easy enough to solve as well with other security.
You could do the old staple of locked down Linux laptop for your banking or anything of that magnitude. Whatever else you like for boring or old forums, social media timewasting and all that jazz. Similarly password wise there was the "important things get their own password, possibly also email account, everything else gets same junk email and password, or do it in tiers of less and less useful stuff".
With that said keepass is where I would point people if they wanted an offline database. Know what you are doing (data that does not exist in more than one location does not exist, there is no way to store a plain password with the encrypted data securely) and it can be made to do good things.