In terms of longevity MDisc is king (1k years estimate). How does tape compare to drives and ssds without power? and what kind of environment is required? Someone mentioned losing 5k$ worth of tapes to temperature hike.
Further, DVDs are effectively obsolete these days and MDisc's Blu-Rays have no scientific studies backing their claims to longevity compared to competitors like the DVDs did. One of their largest advantages relative to DVDs is completely gone in Blu-Rays as well: The inorganic dyes and recording layer (these are now standard for essentially all BD-Rs).
[0]: https://www.lne.fr/sites/default/files/inline-files/syylex-g... and full test and results in French: https://francearchives.fr/file/de7f8ea96ceb4ce38eb6d9278b3df...