When it comes to Password managers there's a lot of choice to be had. As with pretty much every aspect of security there's a tradeoff in usability. Depending on your threat model you either want to pick a more user friendly sollution like LastPass or a slightly more advanced solution like KeePass.
Web-based VS. Local
The best way to distinct the vast offer of password managers would be to split them up into two categories: web-based and locally stored.
Examples of web-based managers:
- Often well-integrated
- Synching taken care of
- Friendly User Interface
- Easily share credentials
Examples of locally stored managers
- Full-control of database and storage
- Fully Open Source and peer reviewed
- Free choice of client software
- Eliminates trust
Now these lists above are far from complete as the offers in this space are vast and this market is currently exploding. More and more people understand the need to keep their passwords unique and password managers are just a very useful tool to keep track of all your secrets.
"The nature of this data is so crucial and you want to be absolutely sure you have some level of control"
Personally I think there's a huge benefit in picking an independent and Open Source tool like Keepass for this job since the nature of this data is so crucial and you want to be absolutely sure you have some level of control. It does come with the added responsibility of making sure you don't ever lose your database file.
"With online stores like LastPass it's very easy to securely share your credentials with your SO."
One drawback/consideration of using a local tool like Keepass is that it's harder to share passwords between you and your significant other. With online stores like LastPass it's very easy to securely share your credentials with your SO or friends as long as they are also a member on said platform. There are ways of acchieving a similar experience with KeePass but those require quite some additonal configuration.
Picking what's right for you
The bottom-line is that using pretty much ANY password-manager is better then not using one at all. In the end if your current strategy is either using the same password everywhere, incrementing a number or plain writing it down you can pick any and instantly improve your security.
Stay safe out there! :-)