I *was* a heavy user, esp. because of the "PRIME" noise reduction (from v9 IIRC), and also for the advanced geometrical corrections (anamorphosis for instance, when using super wide angles). In this respect DxO was quite unique, and still is. The latter feature has become extra payware though, if I am not mistaken.
On the other hand, the default color profiles are not really subtle, but that can be corrected. Another strength is the batch processing.
Since then I moved to LR because of the cataloguing system, plus excellent overall performance. Besides, cameras have become less noisy and the NR feature of Lightroom caught up, to some extent, soI do not really bother. Also, the geometrical corrections now proposed by LR are real time savers.