In theory AI Clear fights noise and can sharpen the image (without much control over it).
The other tools would work better with a noise-free image.
The names basically tell what their main function is. From what I remember Detail was quite good for getting a "detailed" look that sort of doubled as sharpness.
Plugins, pardon me, Adjustments that are used in Topaz Studio are the way they are moving forward, so the rest may face lack of updates at some point in time.
You can trial everything from Topaz, so doing your own testing will probably provide the best answer.