I am not very familiar with Lightroom, but I used Photoshop and Gimp in the past, and experimented with other FOSS photo editors, always coming back to Darktable.
I conceptualize Darktable as a set of parametrized image transformations applied in sequence. This is not unlike a lot of other non-destructive editors out there, FOSS or commercial, but Darktable is different because the parameter space is huge (actually infinite because you can duplicate and reorder modules, but huge even with the default pipeline).
There is a style of photo editing that is prevalent in some circles, and it goes like this: there is a bunch sliders, relatively few, and you keep moving them left and right until you get the desired result. A more sophisticated approach is that there are groups of sliders, pretty well related to some single aspect of the image, and you keep fiddling with them to get what you want.
This kind of “exploratory” photo editing has very limited support in Darktable. Yes, there is the Quick access panel, but it is very basic and if one is using only that with the default setup, there is no reason to use Darktable at all.
I find that the best way to approach a photo in Darktable is to decide what I want, eg “increase the contrast in the sky”, and then figure out how to do it, where I usually have 3–5 options with different module or module chains.
But this requires an understanding of what modules actually do. Each module has to be learnt and understood, which itself is an iterative process (I revisit tutorial videos after a while to gain a deeper understanding). It takes a lot of investment, but when that is made, it is a very liberating experience because the modules are so powerful and a lot of thought went into them.
Conversely, if a new user just starts “experimenting” with the nontrivial modules without intent to learn, chances are high that they will just mess up their photo beyond redemption. One does not need to cite diffuse or sharpen as an example, color calibration is like that too: a perfect footgun if you don’t understand how it works, but if you do, extremely powerful.
What about the new users? I guess that the harsh truth of Darktable as is is that they have to decide whether they want to invest the time in learning at least the fraction of Darktable useful for their editing style, or pick another tool. It is definitely not a plug-in replacement for Lightroom, and frankly, none of the developers are very interested in evolving it in that direction so that’s probably a how it will work in the future too; which I am happy about because it is a tool that suits my purposes.