I'd recommend reading the printing and labelling thread - lots of LightScribe users posting there, plus images of what the discs will look like.
I use LightScribe sometimes - more of a novelty than a serious printing technology IMO, but I still quite like it for doing things like compliation CDs for the car.
It's better for CDs than DVDs, but many users are reporting poor contrast and poor drive performance with certain drives and media. (personally I haven't had any problems using a LiteOn drive with any media)
Read the threads - it should allow you to make up your mind.
Also, if you do use LightScribe and want free software that is better than Roxio, I'd recomment SureThing which is a free download from the LightScribe website.