I don't know about the other programs but for me LR has always worked nicely. The 2012 process version does a great job and LR controls are easy to use, makes editing and exporting super quick. I also have PS but that only gets used sometimes for it's masking ability. Most stuff can be done with LR. I wish Adobe would include a better healing brush tool in LR though.
Interesting about the Digital Lens Optimizer in DPP. How does that differ from the Lens correction profile in LR? LR 4 has distortion and CA separate.
I upgraded to LR5 the first day (after using the beta). There are some bugs, but they are not important to me, since I do not sharpen my output.
You are in no danger of losing your images. Lightroom works with a database which records the edits. When you export a file, it applies the edits to a copy and exports that without ever touching the original.
There are a few Adobe haters who make up things or distort them out of reason. To be fair, there are some who are just the opposite. A lot of us are quite unhappy with Adobe and the so called Creative Cloud, but that's no excuse for grossly exaggerating any small issues.
The way I see it, is that its a software tool, and like all software, it has bugs which will eventually be fixed, and the fixes will cause more bugs. They are usually very minor and easily avoided, but it is definitely a good idea to understand how they apply to you and your work.