I knew/know there wouldn't be a quick fix to this. I've been obsessing with Time since a trip in 2008 where I used multiple cameras and tried to put all the pictures into one folder. Over time I've seen bugs in how camera manufacturers stamp still and video images and how photo manager applications mishandle timezones and try to use location information to adjust a photo's time. (The latter is what has pushed me once more over the edge.)
After posting, I found that even though all my photos have "EDT" reported by Photos, photos are really in EDT or EST depending on the date taken. I.e., when "slamming" them into UTC, I need to adjust by 4 or 5 hours, depending on daylight savings time.
I went over my camera once again and noticed that I had it set to London/No Daylight Savings time - which raises the question of why Photos stamps my photos with EDT. (I live there, maybe that's from the system setting.) This has increased, rather than decreased my level of satisfaction. (I don't blame Photos for camera bugs, but some more features might help treat the problem.)
I have gone through some photo sets that crossed time zones, different cameras (models and manufactures) and have been able to get Photos to show the pictures in the correct order. That involved setting the time to UTC and the time value to the time in UTC, despite locations showing where I was. Outside of a few "how did that time get stamped" related only to phones (apple and samsung too), this worked out. So, I am hopeful this can be worked out.
This problem is a candle burning at both ends. Cameras are buggy in stamping images, not to mention clock drift. Photo managers then mangle the time data in ways that I still haven't reverse engineered. I'm spending way too much time on time.
It would be helpful if Photos did this:
1) In the info box, show the timezone (instead of having to pull up Adjust date and time).
2) Allow filtering based on the timezone.
3) Allow setting the timezone without fudging the time value.
Given the daylight savings time issues with some time zones, the last feature would be most helpful for me.
In closing, I agree that entering the photos with the correct time stamp is the best start. Besides the "bug" I just found (my camera was configured for UTC but the import set the photos to EDT), I've been managing photos since before times zones were a settable value so I have lots of legacy. (Mind you, times prior to the digital era are estimates, etc., so my need to fix is really only for the last 10-15 years or so.)
And for me the problem is significant because I've travelled (mostly for work) excessively for many years, carrying multiple cameras, wearing a lot of snap-and-shoots out, with a lot of time zone crossing as well as collecting co-travelers' photos from time to time. That's why this is a big deal for me, even if it's a edge case in the realm of photography.