I am not really new to STO, been on the forums since years to be honest just never got around to playing the game!
So other than the ingame items there is no real benefit if i buy the boxed version i take it?
Teh game activation codes give you 30 days of Gold Account status with all of the benefits. And anything that you gained above the Silver Account feature you retain when you revert back to Silver status.
Buying like the collector's edition of the game, aside from the fancy little box and such, does provide a nice extra item in the form of the Red Matter Capacitor which is a ship device (you can unlock it on all your characters) that every time it is used, it boosts all your power levels for a short time.
None of the items are really game-changing, but they are nice. Most would say the Red Matter Capacitor is the best of all of them.
Oh yes, when mopping...don't try and clean the spots on Admiral Quinn, he...doesn't like it.