...the diplomacy in RTW...my great pain.

A shame that all this is so hard-coded, in fact.

Does anyone here have seen the AI working an intelligent diplomatic scheme ?

Even with one last town besieged and no armies at all, this dumbass won't give up their freedom.
And, if by luck they accept, be certain that they will betray you in the year...