This is a tricky subject.
There are no publicly available longevity estimation studies since c. 1998.
Dyes and disc manufacturing methods have progressed since then, so it's very hard to say which discs are good.
However, if you go by theoretical figures, then I'd trust Taiyo Yuden and MAM-E (Gold Archival, advertised longevity 300 years) myself. This is for discs that are stored professionally and are NOT in everyday use (i.e. exposed to abrasion, dirt, radiation, etc.)
If you want to improve the likelihood of discs staying in shape, store them:
- room temp (ideally max 25C, avoid big temp changes)
- low relative humidity
- away from light (esp. UV and infra)
- away from noxious gases (ozone, sulfides, etc)
Don't write to the cd surface (except the clear inner ring, if you must) and avoid working with dirty (or greasy) hands.
If you need discs that last a long time in every day use, consider Verbatim Crystal Super Azo discs (very tough label side protection) and MAM-E diamond coated discs.
Also, be sure that the initial C1 count is relatively low on your burns, with the drive that you intend to read them in. This can also improve longevity.