Photo library management bake-off

I've worked with several different photo management/editing apps over the years. I've used both Apple Photos and Google Photos for the last 10 years-ish. I never quite fell in love with either. Back in early days with my first digital camera, I used and absolutely loved the now long dead Picasa. It had just enough features without going overboard In complexity, and wasn't hell bent on locking users into their proprietary little world. I do have an ever increasing list of requirements for photo managers as I've been snapping away at pictures over the years... Can quickly do basic lighting fixes and crop photos. I don't need hours and hours of computer work every time I take pictures... I spend enuf screen time as it is. Allow me to manage and search for metadata: Keyword tags, ratings, Camera name, Lens, and hopefully GPS. Allow me to manage my photos using normal operating system directories and files. This makes it easier to use multiple tools if need be. Importin...