Insurrection is an alien of the week story.
ON THE BIG SCREEN
First Contact was an awful movie and it still amazes me people still praise it. I'd rate Insurrection ahead of it.
The problem with TNG movies is none of them felt like actual movies. There was no grand story that TOS had.
TMP: Refit ship and the crew is getting older. Kirk is struggling with his new role in Starfleet.
TWOK: Same common principal but now the entire crew has been regulated to being a bunch of babysitters for trainees. They are past their prime and no longer on the front lines. They face an old foe from their past. Chekov also gets to be First Officer on another ship.
TSFS: A direct continuation of TWOK story. There is no indication the crew is going to remain together. They are forced to steal their ship to try and save one of their own. Kirk loses his son and his ship to save his best friend.
TVH: A direct continuation of the past two stories. The crew has to come home to face their punishment and instead manage to save the entire Federation.
TFF: No direct continuaty with the other stories other than Kirk being a Captain again and the ship being "new" but constantly broken. By far the weakest story.
TUC: The final mission of the greatest crew of Starfleet. Deals with the crews age and wraps up Kirk's feud with the Klingons, killing his son. Also gives a promotion to Sulu and continues the Excelsior subplot established in 3. The two ships, once foes, are now allies. The Excelsior subplot is nicely done throughout III, IV and VI.
TNG had no on going arc. They tried to do a Picard is old arc in Generations but that went no where. There was no concept of the crew actaully moving on with their careers until Nemesis. TOS had Chekov has the FO on the Reliant and Sulu as the captain of the Excelsior. Both were HUGE parts of the plots.
TNG had Worf just happen to be in the area. FC's Worf's introduction made zero sense because they were too cheap to pay for DS9 actors to join the story.
The Death of the Enterprise-D is not even that powerful when you compare it to the death of the original. Kirk's line of "My God Bones what have I done" and McCoy replying "You did what you always did. Turned death into a fighting chance to live". The Enterprise D had Riker making a joke about the chair and I remember thinking when I saw Generations in the theatre they were going to beam the chair up with them! The death fo the Enterprise D was too happy.
I agree with 99% of what you're saying; but I think the point with the D was that it was just a ship, it held no reverence as it's the people who crew it that make the difference. It seems the only one who cared about the ship was Worf.