Insurrection is underrated. It's by far the best TNG movie as far as pacing goes. First Contact feels like it is stuttering and I think people like it mostly because the Borg are always a hot topic for Trekkies.
First Contact did have its fair share of stupid (Borg queen, UGH). I just thought the plot made way more sense than any of the other TNG movies.