Well... I read a lot of things here. We could discuss the topic for hours (even if I think that it has already been done) but I believe an example is worth a whole explanation.
Basically, and it has already been said, if you intend to produce "small" prints (that is to say for example 8x10 inches max with an 8mpix cam), and if you are sure that you have selected the right white balance and the right exposition, don't bother with raw. BUT if you are not sure of the white balance, the contrast, the sharpness you want to apply and that you want to produce a BIG print, use raw. There IS a gain in detail with raw. In fact, the in-camera processing does a great job at retaining detail as well as containing noise, but it makes a compromise, and you cannot change anything to that. But if you shoot raw, you can do this. So, yes, you will get more noise, but you will also get more detail. Or the other way round. But finally you can do that home, quietly in front of your screen, and not in a rush, when taking the picture and concentrating on the subject.
Oh yes, I forgot to mention...I upsampled both samples from a crop of 500x500 to 1000x1000 in order to see the differences easier.