I admittedly can't even remember Insurrection that well, except I think I thought the story was silly at the time? Had somewhat the same response to Insurrection that you did to Generations, I'm guessing.

Mileage it varies, you know? ;-)

Finale Frontier? I remember the creature was red, had horns, and acted like the Christian mythology version of the devil...but it was over 25 years ago that I saw it, so it's possible my memory has merged it with something else. Mainly I remember how cheesy the script was, the horrific special effects.