Diplomats do get better. They gain in Influence, which doesn't seem to make a whole lot of difference in the deals they can broker, except when it comes to cash transactions. A 10-influence diplomat will often be able to sell Trade Rights for 4000d or up to most factions (except the Romans, curse them!), while a zero-Influence diplomat will have trouble selling Trade Rights for even 500d.