Insurrection isn't bad! I like all star trek, but Insurrection had a strong message and held true to the meaning and virtues of what gene Roddenberry envisioned. Like SpaceMarines said, it came closest to recapturing the feeling of camaraderie that the original cast had as well.
It had some weak moments, the effects weren't great.. but it was a good TNG movie. First Contact is still the best though.