Drop synchronous connection modes

No existing connection provider supports this, it's not widely needed and
the user can implement it themselves easily enough on top of a completely
async solution.
Fix some race conditions in TempestClient disconnect
Fix mock connection disconnection