It’s probably optimum to have hundreds to low thousands of users per instance but it’s going to depend entirely on the level of overlap the users have in terms of external communities they access. If you have 1000 users each subscribed to a single different community with no overlap, then there’s no benefit at all.