Perhaps instead I should have suggested some sort of TNG/DSN crossover on television, during DSN's run.
Sure the budget would have been smaller but the story would probably be less 'blockbuster'-ey and more true to the series.
Allyn Gibson brought up a few reasons why on why First Contact is rather flawed, fun to look at but not that good of a Star Trek story.
Outside of any meaningful real world or historical setting, "war" just comes off as trite. It's extremely difficult to make it compelling in a single film because there's such a disconnect.
The scope that is required is simply too big to fit into a single film and focusing on any single conflict or battle doesn't work without context.
I was not trying to glorify war or conflict in any way but just thinking of a story idea that could be reason enough to bring the two crews together for a united goal or task and at the same time come up with something that could surpass the theme and visual action of First Contact.
The thing is with the Dominion - or at least the Jem Hadar - they are quite a grim and miserable lot. The Vorta are slippery and somewhat amusing but that ain't enough to carry any particular film really is it?
Well those would be mostly background characters/henchmen, perhaps one of the DSN regular 'leading' type of antagonists or a new antagonist would have to be introduced that would be the leader or architect behind the plan that the TNG and DSN crew would have to stop.
The stan in me would love to see Kirk, Picard, Sisko and Janeway together with their crews taking on some universe destroying entity but the TNG movies struggled with 7 main regulars so I'm not sure what they'd have done with the combined casts of all the shows.
True but in a lot of movies based on shows there are always a bunch of characters who suffer from being underused or less quality of writing because it sometimes difficult to find something for them to do that is on the same level as that of the main characters of the story.
In a series you can at least occasionally throw such characters a bone, in a hypothetical TNG/DSN crossover like I suggest it might be very difficult to find a good sub plot for Quark, Garak, or Troi. (I am surprised that they some of these at least got some decent part in the "Telepathy War" crossover I mentioned.
In First Contact it felt that Troi, Riker, and Geordi were dumped on Earth to hang out with Cochrane because the writers had no idea what to do with these characters if they had remained on board the Enterprise during the Borg fight.
I guess the idea is more the exciting than the actual result. I just wanted to come up with something that I felt would have been stronger than Insurrection.
Nemesis is a whole different can of worms.