While it’s hard to say for sure, I would expect to get at least 20+ years out of your typical Verbatim (or Taiyo Yuden) media as I have some that’s 10+ years old and I don’t expect it to fail anytime soon. I may have some around 2000-ish but I have not check those in years now even though I got a fair amount around the 10+ years range, and maybe around 15 years.
but those claims of 100+ years you see online here and there over the years, I would not take that stuff too seriously. hell, even if by some chance it does make 100+ years, no one is going to care and not only that, even if someone did care, will DVD drives that can read those discs will still be around? ; because I think finding DVD drives that can read DVD media won’t be hard to find for at least another 10+ years, who knows what it will be like in 20-30+ years from now.
still, I prefer using DVD (Verbatim or Taiyo Yuden) for backing up family photos/videos as I consider them a pretty reliable backup to my copies on hard drives. like short of a house fire (and the like), chances are losing my data is slim. but being hard drives are much cheaper than using DVD media for a while now, most of my general data I just use hard drives with at least two copies (one hard drive, and another) which gives me reasonable protection against data loss but any high priority stuff I also backup on DVD media.