I am aware of in-filestore corruption of my files including images, and I know I have holes but the curation failure is more in 1984-1990 than after digital cameras entered my life and a scanner is rectifying some of that. But it's a road of tears regarding metadata.
More worrying is the failure inside cloud. Takeout from Google suggests some bitrot lurks in the assets there too.
That 1200bpi reel of tape, and the pre DLT tape cartridge are a worry: media may be OK, readers are rare and services doing recovery charge significantly more than "photo memories of granny" costs.