For home recording purposes, I've been using Gigaware brand DVD-R's, Radio Shack used to sell them. I haven't had problems with these discs and so far none of them have dried up and become unplayable. A few discs wouldn't finalize once I was done recording, but that's the only issue I've had.
From my experience, it seems that pressed DVD's are the ones that can sometimes develop disc rot over the course of time. DVD-R's don't develop disc rot, but over the course of time the purple dye layer can occasionally dry up which will eventually make the disc unreadable and unplayable.
The...