I think you're being somewhat unrealistic here. This is a give-away app aimed at folks taking snaps with their devices and wanting to share them across these devices easily. Just because it will do more doesn't mean it's optimised for that. You can write a doctoral thesis with TextEdit, but you'll have a much better experience using an app like Scrivener, Word or Mellel.
I just wish Apple would be upfront and clear about their products' limitations.
They are. But the information you want is dependent not only on hardware, which can vary wildly, but also the user's perception of what is acceptable - as Léonie's post demonstrates. So, as I said, the limit of size is dependent on disk space. What you regard as acceptable is something that Apple cannot know. So, how slow is too slow for you but not for Léonie, or vice versa, and how are Apple to know this?
Simply springing changes on us, e.g., from iPhotos to Photos, from iTunes to Music, should be illegal.
Apart from things like media coverage, which was extensive on both of these changes, the Apple website for the relevant versions of the OS and the applications also covered these changes comprehensively. So, nothing was 'sprung' on anybody. And to characterise product evolution and development as 'megalomaniacal' is beyond absurd. None of these changes were forced on you. You didn't have to upgrade, you could simply have stayed as you were. Both sets of changes offered a simple progression to migrate to the newer app. If you installed these upgrades without the most basic checks in advance to understand what was being installed, and was then surprised, that's down to you.
You're absolutely right about the countless hours we have to spend managing their products' shortcomings...
And this is consumer choice. If you find the application doesn't meet your needs then by all means use a different one for the job. There are alternatives, and they are all more powerful than Photos, as you would expect when they are not give-away apps.