Worth it? Definitely not. They have a high purchase price, as you'll need a higher watt model then you think for your tank size, and you have to replace the $20-$75 bulbs every 8-12 months. And in the end, it is still only proven to help against algae.
That said, if you're looking for another piece of equipment, and don't mind the cost, go for it. I had one on my 125gal, but won't be getting one for the 240, due to costs for the 50-75watt sized unit I'd want.
As for using on a hospital tank, if you actually mean a hospital, where you have a severely injuried fish/coral, yea, one can be used there, but definitely no point to using a UV on a QT. You can't use them with medications, and to be honest, if my fish have a disease, I want to see it. I do not want it to be artificially suppressed by the UV.