I love diplomacy, it's a good source of cash for me, and it lets me end wars and/or the game without having to chase sovereign's down to their last town.
This is my attitude to diplomacy in this game and I have grown to like it. Don't trust the AI to hold to treaties they only respect your strength. View treaties as restrictions on your own options but not on theirs.
If you want to be safe against treachery build up your faction power. Recruit troops and champions and level them up and the AI will not (usually) attack a stronger power, at least I haven't seen it do that yet.
Once you are stronger than some of the AI factions they will want to form a Non Aggression Pact and will pay for the privilege. Then use that gold to set up the economic and trade treaties. Only do this with weaker players and then you get the full benefit as long as they survive and these treaties give 10% more gold in your capital and 10% more gold overall and that soon builds to a nice surplus each turn. This extra cash easily pays the increased maintenance of the extra troops you had to build to become a stronger player so don't worry too much about the financial implications.
When you need even more cash sell off your research or surplus resources to the weaker players or to a faction that can't use the resource well (e.g. sell ore to Resolyn whose trained troops are weak and who doesn't research warfare techs much). Make sure the trade partner has at least 250 gold before selling a lot of techs or resources and they will value gold at the normal rate instead of counting it double. Just use your own gold to buy something useful until they have 250 gold and then clean them out selling whatever junk you have for their gold.
The other AIs are a major source of resources and tech once you know how to manipulate and milk the system.
JJ