I know this reply does not address all your very specific questions, but after reviewing them I can say that, sorry, but, Connections is not going to be a good fit to meet your stated requirements.
