UV sterilizers are especially useful when the tank is new to control any bacterial blooms, dinos, etc. Used to have all kinds of issues with seemingly random tissue necrosis without any parameter swings, but UV fixed that issue in 3 separate tanks. I always notice a sudden increase in alk and nutrient consumption and now run them 24/7. It really was the turning point for me, where I now feel confident I can keep things alive long term.
Probably true that UV kills bacteria in the water column, I think that was verified by aquabiomics. But I've never seen any evidence that the bacteria is actually beneficial. Just that those species tend to be in the water column on natural reefs. IMO worst case the coral have less bacteria and plankton to feed on, but that's easily replaced with reef roids and other coral food. I still get good growth on most of my acros, so I don't think UV is killing anything crucial.