In general, it varies.
There are cases where the convergence is quite fast (for example in the case where the system is mixing, and say in the presence of spectral gap, think of Bernoulli system or say geodesic flow on $PSL_{2}(\mathbb{R})/\Gamma$).
On the other hand, the convergence can be rather slow in Kronecker systems (hence also in the Kronecker factor of your system, which will appear in the Hilbert space $L^{2}(\mu)$ unless your system is weak-mixing).
The reason is simple, you need to estimate the exponential sum $\frac{1}{N}\sum_{n=0}^{N-1}e_{\alpha}(n)$ where $e_{\alpha}(x)=exp(2\pi i \alpha x)$ and $\alpha$ is the corresponding eigenvalue. In the case that $\alpha$ is Liouvillian the decay rate of this sum can be rather bad. Somehow the most precise results appear in the famous Green-Tao paper about nilflows - http://arxiv.org/abs/0709.3562 .
ADDED IN EDIT - just a few remarks over the first part of my answer.
Even in the mixing case (think about Bernoulli system, or horocycle flow), is that you have some sort of shift operator (this is not entirely correct in the horocyclic case, I'll correct that later), and then the mixing statement (which implies the mean ergodic theorem) is basically equivalent to the fact that $\lim_{t\to\infty} \int_{X}f_{1}(T_{t}x)f_{2}(x)d\mu(x) = \int f_{1} \int f_{2}$, where $T_{t}$ is some shifting operator and $f_{i}\in L^{2}(\mu)$ (you should think about the Bernoulli case here).
In general, unless you limit your functions in consideration to a nice set of functions (say certain decay or smoothness or limit their support), you won't be able to gain anything substantial (think about the Bernoulli case, with two long cylindrical functions, where you will need to shift for quite a lot of time to make them independent, and you may take the cylinder to be as long as you may like).
Therefore many of those mixing results would be true only for certain class of functions (Sobolov is quite a common choice, Lipschitz usually suffices).
Regarding the horocyclic flow - by taking the "non compact line model of a principal series representation of $SL_{2}(\mathbb{R})$", whatever that means, you can find a nice "portion" (actually, a prototypical direct summand) in $L^{2}_{0}(G/\Gamma)$ which will be isometric (and actually, infinitesimally equivalent to) $L^{2}(\mathbb{R})$ and the action of $U_{t}$ is equivalent to shifting $U_{t}.f(x)=f(x-t)$. This shows that even in the nicest mixing system one might possibly imagine, one can get vectors for which the correlation decay would be as slow as you want (and as the system is mixing, the Kronecker factor is trivial, there are no non-constant eigenfunction to play with, in contrast to the situation I described above).