Insurrection is often complained about, but I liked it. It essentially felt like an extended, cinematically filmed episode of TNG. It didn't go all out with tons of huge space battles, the Enterprise didn't crash or almost get assimilated by Borg. It was almost an "Elevator Episode" of Trek films, I think that is why it was kind of a let down to people, they wanted something epic like time travel and big space battles, and instead they get a pretty small stakes story about the fate of a small community.
As for ST continuity, I agree with most of what FF said about it. They change things at their convenience as the story goes on to make things work better. Fair enough. One of the things I really hated about the series Enterprise was when they would try to explain plot wholes throughout the series. For example we have the augmented Klingons loosing their head ruffles to explain why they did not have ruffled heads in TOS. A much easier explaination is a limitation on makeup back when TOS was filmed and a decesion to make the Klingons look more interesting in ST:TMP. We don't need to know why Klingons have pink blood in STVI, but red blood everywhere else, in the real world we know it was done to make the film less violent. Any series than spans the period of time ST has and has as much material as ST has, writen by various writers I might add, is bound to have holes. It is better for the story to continue and pretend there are no holes than to try to go back and cover them up, especially if the holes originate from a forty year old TV show.