Some people say it affects your fish's immunities because it kills all the baddies so your fish ends up like a "bubble boy".
But my response would be, i doubt it.
Just introducing my arm to the tank for water changes introduces bacteria to the tank. Along with the siphon and any new decor and even new water from the tap.
Their food has bacteria on it too.
There is always a supply of bacteria that they are being introduced to. There's no way it goes through the UV sterilzer before it can reach their system ALL THE TIME.
The only way there immune system could be weakened is if every tiny thing was sterilzed before going in the tank and it was completely sealed and away from any "dirty" air.
I have one. I got it as a freebe when i bought the tank from my LFS.
Its on my 125. It's 18 Watts.
I use it because i already had it. No point in letting it sit there.
If i didnt have it, i wouldnt buy one. Not entirely necessary unless you are in an area with poor water quality.
So thats my response to that.