For modeling count data that arises as the sum of Bernoulli random variables or according to an occurrence process with constant rate in some interval, there are many techniques, like using a Binomial distribution, a Poisson distribution, a Poission-Binomial distribution, zero-inflated models to handle over-dispersion, and many others.
All of these models share the property that the variance of the outcome count variable increases as the number of observations increases. For example, if a Binomial distribution arises as the sum of $n$ iid Bernoulli variables with parameter $p$, then as the location parameter $np$ shifts to the right (gets larger) as a function of $n$, the variance $np(1 - p)$ also gets larger. Same with a Poisson where the variance and mean are equal.
Consider a counting problem where you do not expect this to happen. It could be that you believe the parameter $p$ decreases proportionally as $n$ increases.
It could be also be something similar to a zero-inflated model, where each time you increase $n$ to $n + 1$, it is overwhelmingly more likely that you'll add a new observation $i = n + 1$ for which the corresponding Bernoulli has $p_{n + 1} == 0$, and it will not contribute to the overall count or variance. Only a very small fraction will contribute, and in fact that fraction might go towards 0 as $n\to\infty$.
Another example could be some type of "follow the herd" phenomenon, where as more observations are included, the count distribution looks like a discrete distribution over a small set of outcomes, because almost all of the underlying Bernoulli random variables snap to having $p == 1$, but a select few "dissenters" remain possible of randomly contributing 1 or 0 to the count, and those dissenters express all of the source of variance.
Do there exist discrete count models like this? Specifically with the property that as $n\to\infty$, the variance either stays constant (and potentially is described by a totally different parameter) or converges to 0 (so that the distribution gets tighter as the sample size increases, rather than getting wider like Binomial or Poisson).
I could use a Normal distribution as an approximation, but even so, I would need a way to base the choice of the variance parameter on some underlying count model which could not be like Binomial or Poisson or Poisson-Binomial, where variance increases as sample size increases.