I have used KeePassDX on my FP3 (default operating system, not /e/) and I am very happy with it. It meets the requirements of having categories and being able to add text notes to the different entries.
For me (especially when it is about security / personal critical data etc.) Open Source is a must have.
Even I in person cannot double check the code it still provides transparency and so trust.
Due to that I would go for KeepassDX (and I actually use it) instead of 1password. But everybody can decide on his/her own.
AVOID LastPass like the plague!
They got breached on more than one occasion. Because of that I switched to BitWarden and it took 50 hours for me to change the passwords and credentials on every site I had stored.
I need access across multiple devices so that’s why I personally have a cloud connected app.