Rotating Images (Still) Does Not Work Properly

I originally asked this question 9 months ago. Since then, I have created a new user account, and created a new library in the photos app. Which, is a major PIA considering I had decades of photos on there that had been put into albums, tagged with keywords, and favourited - and I've since lost all of that (I think keywords stuck? But, besides the point). I'm still having the same issue. Original question copied and pasted below.

"I have a strange issue with photos and rotating images. There are images that I'm sure I took the photo in the correct orientation, but some photos will appear in the incorrect orientation in Photos on my MacBook Pro - in fact, the photos appear in the correct orientation within the Photos app on my iPhone, but not when imported into Photos on MacBook Pro. When I try to correct it within the MacBook Photos app (from the preview, or Edit, or the library shelf view), I will press the rotate button and it works for most positions but it seems to skip the correct orientation. Sometimes it appears to hold the correct position, but if I switch between library shelf view and preview, it changes back to the incorrect position.

Like I said, it's a strange issue. The photos are being taken with an iPhone 15 Pro and are being shot in RAW format. They're being imported onto a 2021 iMac Pro. This issue doesn't happen when I use my iPhone 11.

All software on all devices is up to date.