Well, it does make a difference whether you are a roofer, baker, or application developer.
Aside from the comment, what do you mean by that?!
Until the disability insurance pays out, quite a lot has to happen; a significant portion of cases also end up in court.
It pays when you are occupationally disabled, as the name already says.
The respective definition and the accompanying scope for interpretation are contractually stipulated. There certainly are (cheap) policies whose "small print" can cause a lot of trouble (e.g., abstract reference or badly formulated health questions), but that does not make occupational disability insurance per se bad, just the specific policy... and you do not have to sign that.
Analogous to the example of house construction with a general contractor – just because some GCs use poor service descriptions and sneakily take advantage of the builders (and ultimately may also end up in court) does not mean that building with a GC as such should be vilified.
However, it is damn expensive and the risk is certainly debatable
What does "damn expensive" mean in this context? Sure, I wouldn’t want to pay the policy for a roofer in their late 30s either (especially relative to income), but for the predominantly present "desk workers" here, we are talking about contributions in the range of 100€.
Of course, risks, probabilities of occurrence, etc., can be hotly debated and a consensus will never be reached. Fortunately, most of us will never have to claim such insurance, and even for those unlucky ones who will, it might mostly be only for a manageable period, which could also have been bridged with corresponding cash reserves.
But the fact is also: with a construction loan and children in the background, the loss of the primary earner is potentially existentially threatening. In contrast stand saved contributions over the critical 20-year period equivalent to the value of a garage. For me personally, the effort and possible gain here are in no proportion that would justify gambling.