If you are nodding in the affirmative, Apple has listened to your wish big time!
Hazards like ill-fated photo backup and database corruption cause such issues.
Besides, third-party camera apps are also responsible for this frustrating problem.
So, having a built-in tool to retrieve the damaged images is a better solution.