I took some photos at an event and I need to go through them and get rid of the bad ones (eyes closed, things in the shot, out of focus, blurred etc.) I’m not a pro photographer so no idea where to begin with photo apps. I’ve used RawTherapee and Gimp a bit.
What app will let me quickly browse the photos and handle (delete/tag) photo formats together (both the RAW and the JPG)?
I think OP is looking for a desktop application, not a selfhosted cloud platform.
That’s very likely the case, but I’d say it makes little difference: any self-hosted application supporting web technology is also a desktop application.
Photoprism is not suitable as part of a post editing workflow. It’s a gallery for displaying and searching your photos after they’ve been sorted and edited.