Adobe AI-based NR is not free - you already pay for it. If you insist on not using DxO PL6 but want DxO Prime NR, then you will, as you said, have to process the entire image in PR3, just like Adobe AI-based NR. However, the Adobe AI-based NR IS incorporated in the raw converter, as is DxO Prime and Deep Prime NR in PL6. In PL6 you can preview areas of the full NR to check your settings and then you can continue to adjust your image for output without having to first apply the time-consuming Prime or Deep Prime NR. In Adobe ACR or LR you cannot do this, which forces you to process the entire image before you can continue to edit it, creating a bottleneck in ones workflow. Not wanting to switch to PL6 is understandable, but that is your choice. Because you are willing to wait for the processed DNG to be returned for further processing, it is worth it to you. It is, however, inefficient.
Also, as far as I can tell, you cannot copy and paste the use of AI-NR across a set of raw images (I used LR to attempt this) because you must invoke the AI-NR dialog, wait for the preview to render, accept the preview (or adjust the amount slider), and wait for the file to be processed by the Enhance operation into a separate DNG file. You can copy-paste or sync all other adjustments across images, as you normally would, but to "batch" a set of images for AI-NR, you have to go through the operation individually for each image, render the NR, and then apply the other adjustments back to the new DNG to sync them with the adjustments to the original raw file.
In DxO PL6, you copy-paste the Deep Prime NR setting and you're done. The results are rendered at output render time, when you can leave your machine unattended and go have a cup of coffee.
Like I said, this tool as it is implemented now is a special tool that will not really be useful for a lot workflows - it seems useful for when the image demands a lot of NR to save it, or you simply want to apply this type of NR to all of your files, regardless of whether or not they actually need it.
Of course, one hopes it will get better in its design, interface, workflow and implementation (hopefully on the GPU). I think Adobe has simply been forced into AI-based tools because of smaller companies that specialize in third-party solutions for individual workflow steps. I would be interested in the folks here who demand and use noise-reduction tools (AI or otherwise) and who print their work to comment on the actual usefulness of these computationally intensive applications in the context of real print output, versus zoomed in screen grabs.
Is it even worth the trouble? For example, on the yellow bird image above - ISO 1250 on a modern sensor - is there really any need for NR other than maybe some gentle chroma filtering?
Kirk