Darktable (https://www.darktable.org/) has become very good and continues to be my go-to solution for digital photography.

The delete button is labelled "delete (trash)"

Never change, FOSS UIs

Capture One.

Also, Davinci Resolve has added photo editing functionality since 2 V21 iirc, but it’s not a drop-in replacement. It’s Davinci Resolve though, so expect to be blown away.

Eh, using resolve for photo editing seems a bit like using blender for video editing. It can be done, and it isn't that bad, but there are so many better options

Yeah, I agreed, though I’m secretly hoping maybe Davinci enters this market too

I didn't find one but it heavily depends on your use case

I've been happy with Photomator (now owned by Apple).

It's Apple-only, with versions for iOS/iPadOS and Mac. It integrates seamlessly with the Apple photo library.

It's only "gotcha" (which I don't find to be a problem) is it leverages Apple processing where possible (ie the Apple RAW engine). That doesn't bother me, but if you're a pro-level photog and need some special sauce for your RAW workflow, it might not work.

Rawtherapee, CameraBag Photo.

BMD just added their Lightroom-competitor to resolve studio. It’s pretty new so I imagine it is not as feature rich as Lightroom, but could be worth looking at currently and I’m sure it’ll improve