Investing in a UV should be after proper water filtration (skimmer, refugium, reactor, etc) and lighting has been purchased. UV when kept clean and provided with a slooow water flow, will help to clean the water of waterborne algae and parisites. Other than cost, I can not think of any cons...
For aesthetic reasons, most install the UV in the sump out of view.