I have this weapon and have tested it out on Season 4 content. It does appear to work as advertised.
Borg do not adapt to it, and it does ~51 DPS. If you can get a lock on a Borgie, you can run or leap behind cover and keep on shooting. My Caitian toon joined forces with a fleetmate and we had no problem taking down Borgies on Elite difficulty. I leapt out, fired once to get a target lock and then leapt back behind cover. The Borg couldn't lay a hand on me, and since I was behind hard cover, they couldn't shoot me either.
The weak damage done by the weapon is more than made up for, IMO, by the facts that you don't have to use the Frequency Remodulator and you can fire from behind hard cover.
All that being said, I've checked four different Target stores here in Atlanta, and not a one had a copy of STO left on the shelves. I expect that players who haven't got it by now can only hope that it comes to the C-Store. And I heartily recommend that you buy it if it does (like the Caitian and Aenar boffs) -- it seems to be a very effective weapon.
I bought the Gamestop copy on day one release and got Uniforms, Red Matter capacitor and the TOS Constitution Class Starship.. Seing as how they released the Connie to the Cstore, I hope they release the TR-116 soon; if not then that is BS for them releasing one of my bonus unlocks, but not another. There are plenty of people here willing to pay for it, so Cryptic PLEASE, release the TR-116 to the C-store soon!
Its funny I was thinking this exact same thing earlier this morning and did a search, glad I'm not alone in this. Its actually surprising this hasn't been released in the C-Store yet, please consider this Cryptic.
Well you could get the TR as a pre-order from Amazon France and Game.UK. It looks like a Amazon France copy costs 33 Euros and that's crazy expensive. But the Game.UK digital Deulxe costs 10 pounds. That's a bit more reasonable.
I think keys from overseas work with USA accounts, because I seem to remember at launch overseas folks being able to use USA codes in their countries to get all the pre-order items we had here.
Now the question is if you were to get a UK or French copy of the game would your key include the pre-order item? Plenty of retail boxes and online cd keys seem to still include their pre-order goodies, but is anyone willing to take the chance?