Well, as DigitalDog implied in another thread, Adobe added an AI-based demoise feature in the Enhance photo. It generates a DNG with both Denoise and Raw details applied. You can tune the intensity of Denoise.
Inevitably I had to compare with DXO PureRaw 3, for Which I still have 8 days in the trial period.
Even without touching DeepPrimeXD, just with deepPrime, the results I see after just a few pictures are that with some photos it can be very close after adding sharpening to the Denoise, but in most cases PureRaw DeepPrime is clearly better. I mean, much better. Better details, better contrast, good sharpness. In those cases, sharpening in LR does not uncover the extra details DXO brings.
DeepPrimeXD leaves no chance to LightRoom.
PureRaw is much faster but the workflow is not as well integrated, with PureRaw creating a DXO subfolder instead of putting the DNG in the same folder as the original and stacking them together, which I would prefer.
DXO really did something extraordinary in my opinion.
Regarding the difference in details it is only in higher ISO, pretty noisy photos, like ISO 3200 with a D800. With less noisy images, like ISO 400 on a D850, there is by default more detail in the DXO conversion, but tuning the sharpening in LR brings the same levels of details as DXO.
Is the difference worth 129€? Well, when I see what people (me included) sometimes spend extra on lenses for much less visible differences, I'd say yes.
Edit: I have since tried yet other pictures and it is not as clear cut.