Edit May 9 -- high-level summary of the issue here. $R$ gives a good proxy for estimating collision time, with a slight undercount. Random matrices and graphs give distributions with longer time until collision than what you'd expect by looking at their values of $R$
Suppose I do IID draws from multinomial distribution with probabilities $p_1,\ldots,p_n$. Is there a nice approximation for the $x(p)$, the expected number of draws from $p$ until collision, ie, drawing some $i$ more than once?
In the case of $p_1=p_2=\dots=p_n$, this was shown to be the following
$$x(p)=\sqrt{\frac{\pi n}{2}}$$
From simulations, the following appears to be a lower bound
$$x(p)\approx \sqrt{\frac{\pi R}{2}}$$
where $R=\frac{1}{\|p\|^2}$ and $\|p\|^2=p_1^2+\ldots+p_n^2$ is the probability of observing a collision in two IID draws from $p$.
Distributions were taken to be of the form $p_i\propto i^{-c}$ with $c$ varying


Edit: At the end I've added a Mathematica function that will calculate the complete distribution rather than just the mean. Depending on the options selected, one can find the "exact" distribution or the "approximately exact" distribution which depends on using machine precision numbers which results in a considerable increase in speed.
Original answer:
One can find the exact mean. Using Mathematica below is code that produces simulations from a multinomial to estimate the mean and the exact formula for the mean.
Revised answer:
The following function can find the exact distribution of the time until the first collision or the exact probabilities for a specific number of draws until the first collision happening up to 50 draws or the approximate probabilities when using machine precision numbers.
Consider $d=10$ and $p=1$:
Now getting the exact values:
This can even work for very large values of $d$:
The covers most of the probability distribution in that the sum of the probabilities shown above is 0.999999442316189999555627433782474244630006: