First I played the game when it was brand new and yes, there has been lots of bugs in a single player mode, but nothing major. Just the kind you can easily solve by reloading from last checkpoint... and there are checkpoints every two steps in this game anyway. In Co-op play the bugs were a lot less frequent and it was more fun, since no AI can really substitute for a real player-partner. You can't coordinate your approach with AI, but it was still enjoyable enough in single player though. However, I strogly recommend to find a good co-op partner, because that will guarantee a far more interesting gaming experience. Today I installed the game for a second time, played the most of it and no bugs in the single player to be found. So it seems the developers patched all they could. So far I can't complain about a single thing. Maybe I was just lucky today :)
Right, I'm a trekkie, so I'm biased in this area, but the feeling of really being there, in that universe, was priceless. And there were many little details only fans or very attentive players will notice. Call them easter eggs, if you like. The story was a bit (but just that one bit) over-the-top, but that's part of the fun. Besides that, there is plenty of humor in those well done videos forming the story. I have read that the developers were trying to make it seem and feel more like a movie and that's exactly the feeling that I had. The designs are beautiful and that's what makes it so filmic. All those strange environments and sci-fi elements. Who liked J.J. Abrams's films will like this "movie" as well.