I'll throw in my 2 cents. UV works, depending on what your trying to accomplish.
Given the proper bulb wattage and flow rates it will eliminate green water.
I have just received this product and I can't say how well it works yet. This is my second attempt at a UV clarifier, I ordered one previously from a different manufacturer and it arrived non functional, so I returned it and ordered an Aquatop. I was initially impressed with their customer...
www.fishforums.net
Will it eliminate pathogens in the water? Maybe. I haven't had any so I can't say. Opinions on the interwebs say no, perhaps I will get to experience this for myself some day.
Before I purchased my UV I did A LOT of research on the subject and I ended up getting a unit that was a little over sized for my tank. Stronger bulb and the ability to control flow were key for me.
I think there are people getting confused with commercial UV versus aquarium UV.
The units used in commercial water sterilization have high powered bulbs. This is because the water only makes one pass through the system, so there is only one opportunity to kill anything in the water.
Our aquarium units operate differently. Our tank water is making repeated passes through the UV light. So even if initial exposure doesn't kill a pathogen or algae cell, it will make several passes through the UV unit over the course of hours or days.
Also while I/we say "kill" a pathogen or algae that's not what's really happening either. The UV light actually mutates the algae/pathogens DNA so it can't reproduce. This is why if you use a UV on green water after a few days the water isn't green anymore but it's still hazy. The dead algae are still in the water and must be removed via filtration or water changes.