Whatever you do, DO NOT buy a Creative DVD drive. I doubt that would even be an option since they're so overpriced, but they are completely USELESS.
I got a Pioneer 106S (I think that's the right #) to replace it, but since I don't have a working computer at the moment, I've only used it once.
Most drives are just as functional as the next. My brother has an Acer one and it's never given him problems. My roommate in college got an off brand one and even that one has worked flawlessly. Best to check online reviews, but Toshiba is also recommended by some of my friends.