The diplomacy is definitely the weakest aspect of gameplay in singleplayer, even beating out the pirate/bounty system - mainly because it has nothing to do with diplomacy and everything to do with fulfilling seemingly random objectives.
Expect the AI to create mega alliances/cease fires against you unless you go out of your way to create your own big alliance (which is, in its own way, quite fun - for a very limited amount of time).