...as a rule, peace and peaceful diplomacy is not that interesting.
Speak for yourself. I find stories of combat quite tedious.
And I think you're confusing peace and diplomacy. Yes, a story in which everything's perfectly peaceful and nothing is going wrong would be dull. But that's
not what diplomacy is about. Diplomacy is about dealing with things that
are going wrong, especially things that have the potential to lead to violence, and finding a more intelligent and probably more elusive solution than just shooting things. So there's a lot of tension, danger, and difficulty inherent in it.
Excitement isn't always about characters fighting. Sometimes it's about characters striving to prevent destruction. Like a scene of a hero defusing a bomb. There's a lot of tension and excitement in such a scene, because of what's at stake if the hero fails. And it challenges the hero to be smart and ingenious because it can't be solved with brute force. Well, a diplomatic mission to prevent a war has the same kind of tension, perhaps less immediate but on a bigger scale.
Funny...I was under the impression that the entire point of the Typhon Pact was to create a new bag of headaches for the Federation.
Yes, but war is far from the only kind of international competition or tension that can exist. Look at all the different ways that nations compete, clash, and jockey for advantage in real life -- economic competition, clashes of law and policy, ideological disputes, competition for allies and influence, games of political brinksmanship, you name it.
Sci...I'm sure you are aware that a story without conflict is no story at all. Without conflict, the book is dead. And without a long-term conflict, you cannot have a long-term arc.
True, but conflict in the literary sense doesn't just mean fighting. Conflict means that the protagonists are faced with obstacles and problems, or that different characters in the story have differing goals that are at odds. Conflict can even be internal. For instance, in "The Best of Both Worlds," Riker was in conflict with Shelby over how to deal with the Borg, and in conflict with himself over whether to accept promotion or stay where he was happy. Conflict is anything that makes it difficult for the protagonist to achieve success or resolution. Saying that conflict is needed for drama doesn't mean that every story has to be about fighting. It means that stories are about characters dealing with problems and challenges.