Photos is definitely not great, though I still try and deal with it for the easy iCloud syncing. Some examples off top of my head for Photos crappiness, all on my top of the range 128GB macbook m4 max

- doing 'cmd-R' (rotate) on a standard few-megabyte image might beachball the app for a few seconds. Rotating a small image file...

- Rotating a video seems to re-encode the whole video, instead of setting some metadata flags. Imagine you have, say, a 20GB video recording, and rotate it. That will now be a separate new 20GB file on your mac drive.

- If i view the album of some specific person that has many pictures with location metadata, and I scroll to the bottom where the map is, it almost immediately starts allocating >100GB memory, beachballs, starts gigabytes of memory paging, and you gotta kill the app asap.