I tend to agree that Nemesis is worse than Insurrection. IIRC, Stewart wanted a softer story after first contact - resulting in INS (ultimately). The bits I was able to glean from the Piller book on the subject suggested an original story about an old friend, then later Data betraying starfleet and Picard had to stop him - I may have remembered that wrongly. But Stewart didn’t like the action-focused nature of the story and the only thing to survive into INS was the bit about having to stop Data.
FWIW I don’t mind INS. It’s a nice TNG story - ok, the Baku aren’t that well developed, and I wish they’d kept the Quark scene in, but it captures the TNG feel quite well for me.
NEM makes me sad. In a bleak way. I really have to summon up the energy to watch that film.
Either way, I’m glad that with the Picard show that Trek is looking forward again - I hope it’s not so much that the DSC era becomes negatively viewed overall in preference for a 24th century show.
I also wonder, with the success of OITNB, whether we’d get a cameo from Kate Mulgrew? That kind of mainstream popularity could also potentially polarise viewers away from DSC.
Personally I’d prefer an arrowverse setup where several things are on at once, are connected, but separate from each other. Kinda like Trek in the olden days of TNG DS9 and VOY. Ah, youth.
