Darktable is what you want. You can also use digikam

Another suggestion for Darktable. It handles this case of mixed types transparently. It's a big thing to learn, but extremely powerful and capable, and you don't have to know all the corners of it, just enough for your workflow.

Darktable can do that, but be sure to watch a tutorial or two on youtub (because the most efficient ways to do such a job are not obvious at all):

• Basic operation & use of the GUI,
• importing,
• use of the stars.

Have a look at XNview MP

I can definitely say that it is avery good photo management program.

I am only using about 20% of it's features and it is my go to image software.

Digikam. It supports grouping (or stacking as it's called in Lightroom) by filename, so you can auto group RAW and JPG. It has hot keys for flagging rejects/approvals during initial inspections and review, so you can just fly through them.

I've never had the chance to work with the RAW format, but I think Photoprism should handle it transparently. Depending on your area of knowledge, the setup might feel a bit convoluted though.

I recently switched away from Lightroom and now use a combination of Digikam as a DAM and Darktable for editing. I also shoot RAW+JPG and you can group these photos reasonably well in Digikam

Geeqie is a quick one to go trough photos and it groups RAW+JPG as a single item on preview, so even a few hundred photos are quickly ran trough with just a keyboard. I'm not sure on how well it manages tags as I don't use it for tagging, but it's most likely in your distros repository so testing it out is quick.

nomacs could be an option and is multi platform

Capture One has a free 30 day trial IIRC. It's great for doing this kind of thing, if you put caps lock on you can hit keys 1-5 to rate and it will auto advance.