The best word to describe Insurrection with is "clunky". The plotting, characerisation and pacing is ridiculously clunky. Still, it isn't entirely without merit. Just a really misjudged, messy film.
I don't think we've had a Star Trek film without a clunky script since Undiscovered Country. Though First Contact is a pretty good dumb action flick.
I'd say that II, IV and VI are the
only Star Trek films without significantly clunky scripts.