I still use the Borg gear set on my ship, mainly because it's the only full gear set I have currently. I took some time off from STO and I'm just getting back into it now and trying to catch up.
I like Season 9 for the most part. I was a bit disappointed with the ending of the story mission though. I felt that just as it was rampping up the action and excitement, it pulled the rug out from under me by taking control during the final combat. Having to watch things play out in cut scenes that I had no control over and being forced into an 'on rails' shooter space combat section, completely took me out of the moment and spoiled much of the fun I was having.
Overall, I like all the changes they've made, but their story and gameplay integration still needs a lot of work.