Although this doesn’t answer your question completely, I still think this is valuable to show that you’ll need some very specific or strong conditions. I’ll show by example that it isn’t strong enough to suppose that $f\in C^{\infty}(\mathbf{R}^N)$ and that the corresponding parametrizations $\psi_n$ (for $C_n$) converge uniformly to $\psi$ (for $C$).
Let $N=2$, $f(\mathbf{x})=1$ for all $\mathbf{x} \in \mathbf{R}^2$ and
$$
\forall n \in \mathbf{N} : \psi_n : [0,1] \rightarrow \mathbf{R}^2 : t \mapsto \left(t, \frac{\sin(tn)}{n}\right).
$$
It’s not too difficult to show that $\psi_n \overset{[0,1]}{\rightrightarrows} \psi:[0,1]\rightarrow \mathbf{R}^2:t\mapsto(t,0)$. Clearly we have $\int_C f = 1$, but
$$
\begin{align*}
I_n:=\int_{C_n} f &= \int_0^1 \sqrt{1+\cos(tn)^2}\mathrm{d}t \\&= \frac 1n \int_0^n\sqrt{1+\cos(t)^2}\mathrm{d}t.
\end{align*}
$$
I think it is pretty clear that this integral doesn’t have limit $1$, but for completeness’ sake I’ll provide an argument for those who aren’t bored yet. Clearly $\left\lfloor \frac n{2\pi}\right\rfloor < \frac n{2\pi}$ for all $n\in\mathbf{N}$, and since the integrand, $g(t)$, is strictly positive we have
$$
\begin{align*}
I_n &> \frac 1n \int_0^{2\pi \left\lfloor \frac{n}{2\pi}\right \rfloor}g(t)\mathrm{d}t=\frac 1n \sum_{i=0}^{\left\lfloor \frac n{2\pi}\right\rfloor-1} \int_{2\pi i}^{2\pi(i+1)}g(t)\mathrm{d}t\\&=\frac 1n\left\lfloor \frac n{2\pi} \right \rfloor \int_0^{2\pi}g(t)\mathrm{d}t > \frac 1n\left\lfloor \frac n{2\pi} \right \rfloor \cdot 7
\end{align*}
$$
where we note that $g$ is $2\pi$ periodic, and the last inequality was given by a numerical estimate by Wolfram Alpha. Now considering that $\lim_{n\rightarrow \infty} \frac 1n\left\lfloor \frac n{2\pi} \right \rfloor = \frac 1{2\pi}$, and $2\pi<7$, we can conclude that if $\lim_{n\rightarrow \infty} I_n$ exists, it is strictly greater than $1$.
I don’t know where to go from here in determining sufficient conditions, but I still figured this might be useful.