No Q and no Borg pretty much ended TNG's crew films
There was nothing wrong with Frakes directing, Insurrection I do think didn't build the momentum brought with First Contact. You can't go from the Borg which are iconic villians to a movie where there is no household name ot attraction built into the film from the series.
If they wanted to do a more light hearted type film, I think a Q film perhaps featuring borg plus other villians would of been more cool and more marketable. When Insurrection came out, they tried to market it as a action film, I knew then this was a bad move, but it seemed someone just lost the scope and wowness they had with first contact, they lost the audience for nemesis because insurrection was a step down from First Contact,
Why not have a borg trilogy?
Those opening scenes of first contact are so cool, dark science fiction/blade runner, which is what frakes went for in First Contact worked so well, I can't believe they went in a different direction, it seems perhaps someone made a comment, let's go lighter, the fans will always watch, but the thing with first contact, it actually was a cool science fiction film, and the borg are the top of tng's rogue galley.
Insurrection was the start of the downfall, and Nemesis didn't help it, but went further down. Generations and First Contact offered promise for many films to come, it seems EGO and poor choices ended TNG crew to a crashing hault.
John Del Lancie was great as Q and the humour was always there, I always remembered Q movie rumours popping up, but they never included him, they could of perhaps used him and the borg, come up with some sort of story, these are the iconic villians of the tv series, give the people what they want! First Contact was a success, if you wanna milk anything and get away with it, milk the borg, there's nothing like those Cube shaped ship on posters, and Q would of added a lighter touch in the darkness.
Someone was not thinking regarding Insurrection and Nemesis. I like to think of First Contact and Generatonas as the TNG films, I would own them, but Insurrection and Nemesis is a classic examples of studio/s/producers getting stupid and thick. The TNG crew and it's fans deserved better. The show was not always consistent in quality and the TNG films I'm afraid went the same route, I would of let Rick Berman go a long time ago.
There was also a good chance of immediately starting production on a TNG Dominion war film which could have been a cross-over with the introduction of the DS9 crew to the big screen. It would have been the best and easiest way to have transitioned the DS9 crew to the big screen should they have chosen to then do subsequent films. Their second biggest mistake was not taking Nemesis' final cut from the Director's hands.
A TNG/DS9 crossover movie would get be pumped up, the way of the warrior tv movie is more entertaining then Insurrection. I do think that the crew who did DS9 were not effected by Rick Berman, and that tv show has become more respected over the years, imagine what they could of done with a TNG/DS9 movie.