Several questions: (1) have you noticed whether it reduces noise, sharpens images and adds clarity much better than you can obtain from LR's own tool set for doing these things? (2) Does it need to render the raw file into a TIFF/PSD or does it work on the raw image? (3) If it does need to render the image, how much better is it in Photoshop than using other existing and highly effective plugins such as Photokit Sharpener for sharpening, and Neat Image for noise mitigation, or their counterparts in the Nik Collection which many of us obtained free of charge when Google owned it.
1) The images I have tried it on so far were photos from either the DJI Phantom 4 Advanced or Mavic Pro drones that had already been fully processed in Lightroom, and in some cases Aurora or Luminar. I used those images because the small sensor size does make them prone to noise and the article on LuLa touted AI Clear as being effective for noise which is definitely reduced after running them through AI Clear. What surprised me was the boost in sharpness and "clearness" in a very natural and effective way for most of the images. The images were sharpened in Lightroom already. Some areas with foliage that were already pretty mushy didn't benefit and might have gotten worse in AI Clear but a lot of other features where much better.
2) You have a number of choices about how the file is exported from Lightroom to AI Clear but I used TIFF. I haven't tried working on the raw files directly so I have no idea how it handles that.
3) Although I have Nik, and Topaz Infocus and have used Photokit in the distant past I generally haven't found those plugins to be worth the extra processing step compared to Lightroom and I haven't tried any direct comparisons. I no longer use Photoshop for anything other than specialty things like content aware fill etc. so I can't address anything regarding AI Clear vs Photoshop or plugins in Photoshop.
I know you are generally quite skeptical about these add on programs versus what I agree are the already excellent capabilities in LR/PS but the 30 day demo of Topaz AI Clear is fully functional and pretty straightforward. I would be interested in your thoughts after you gave it a try. After all, I created this post not to tout the benefits of AI Clear but to prompt a conversation with other people that had given it a try.