Not too long ago there was a thread of the exact topic on CN. (And there are such threads almost constantly in a yearly basis.) There I presented the following RGB vs LRGB comparison.

You may just look at the top row. The RGB and LRGB image both contain 208 (209) minutes of total integration. The post-processings are identical, except that the LRGB one of course contains the additional steps for LRGB composition. The subs have comparable qualities and were taken under comparable sky conditions.
It is clear (at least to me) that the LRGB one has better details on faint objects. The LRGB one contains stronger color noise, obviously because its RGB component has shorter total integration than the pure RGB one. The top-right panel contains an additional pass of noise reduction to the RGB part of the LRGB image. This helps to suppress the color noise without compromising any details (protected by L, which did not undergo a noise reduction process). (
Of course one can do the same trick on the pure RGB image (NR on color, not on luminance), but this won't be as effective. This is because in the pure RGB image the color and luminance is correlated. You may wipe out noise spikes or dark holes in the color, but the same spikes and holes would still exist in the luminance, which comes from the same set of RGB data rather than from independent L exposures.)If you compare the top-left (RGB) and top-right (LRGB with RGB NR) panels, it is quite arguable that the top-right is better in terms of faint details. The difference is noticeable, but not dramatic (it's not magic after all).
Bill mentioned about seeing. He is absolutely right. Here I control all subs to have similar seeing (because there is a much bigger pool of subs for me to select). In reality, it's very hard to guarantee all your subs to have similar seeing. If you reserve good seeing time for L and the rests for RGB, the difference in an RGB vs LRGB comparison will be much more dramatic.
One caveat is that one has to conduct the LRGB composition very carefully, otherwise there is a good chance that the color will be washed out. Color washout is one of the most common complaint toward LRGB. I personally don't suffer from this problem (as you can see above, there is not color washout), but I can understand why this can bother so many people. If you are not skillful enough to prevent color washout in LRGB composition, pure RGB imaging isn't a terribly bad idea. You perhaps just need to double (or even less) the total integration time, and then you can get an RGB image that's as good, without color washout or without struggling in LRGB post processing. I would say it can be worthwhile.
Finally, I believe many people saids so already, LRGB is only effective on continuum subjects. For pure emission line nebulas, L offers relatively little advantage.