The tldr is if you're on windows, use keepass base. It has every feature anyone would want and plugins for the rest. It's basically perfect.

If you're not on windows, keepass xc is great, but Id think of it as like keepass' most used features, but less customizable and less absurdly complete.

Android has several the one I use is from fdroid and it's offline-only. Several out there have sync systems, but I use syncthing.