I have the Borg beam on my D'Kyr and I do like having it for the extra hull damage with a 360-degree firing arc. But since it's neither beam nor torpedo for game mechanics purposes it's not affected by beam skills like FAW, Overload & Surgical Strikes, or by torpedo skills like High Yield and Spread.
It does what it does all by by itself, unless you're wearing the complete Assimilated Borg Technology set which adds the beam's kinetic damage to the set's Borg Tractor Beam skill. If you don't have that set but you are using the Assimilated Module from the Adapted Borg Technology set, it gets a combined +15 "all weapons" generic power boost from the console and 2-item Adapted set bonus. There are rumors on the interwebz about the Lobi store's Rule 62 Multipurpose Combat Console boosting it via an oversight/bug, but I have no idea if that's true.
Personally I like it despite its limitations. Your mileage may vary.