I agree it was out of Frakes' hands, considering what he had to work with I think he did the best he could. At the time I was very disappointed he wasn't given the reins for Nemesis.
What I never understood about the inception of Insurrection is the idea of doing something lighter after making the big, action adventure story that was First Contact. Its beyond baffling.