I have to add to this that the solution, for me at least, was as simple as a few puffs of compressed air into the optical drive slot. I really had no expectation of that actually working, but it's been repeated so many times on this thread that I figured the worst that could happen is nothing, and my drive would still be messed up.
For the record, my MacBook Pro hasn't been able to mount any DVD+R media until cleaning it. The problem was only with +R, all other media worked fine. DVD-R, CDR, professional software or movies or discs burned in the office all mounted as expected. I'm shocked that cleaning the drive with compressed air fixed such an isolated problem.
Also in the way of further explanation, when I say that it would not mount DVD+R, it would spin them and recognize them as discs, but the system treated them like they were blank, asking me what I wanted to do and putting it on the desktop as Untitled DVD. I could eject the disc, put it in another machine, and it would mount just fine, with all its data intact.
This happened to me while running Tiger, and continued after the upgrade to Snow Leopard. Resetting the PRAM never worked, I tried that about a year ago while still running Tiger.