I know there are many sites where we can input the equation and get the curve of the function (examples here, here and here).
What I want is the inverse: I have an idea of how I want the curve to be, and want to get to the equation from there. There are some nice lists of curves (here), others not so nice (here), but from there is hard to get to the curve I have in mind. That's the curve in this case (in red):
but there will be many cases when such a software would be very useful. If nobody knows of such a site, then please at least help me identify the equation for the curve above.

Your curve appears to be the cubic spline parametrized by $$ p(t) = (1 - t)^{3}\, p_{1} + 3(1 - t)^{2}t\, p_{2} + 3(1 - t)t^{2}\, p_{3} + t^{3}\, p_{4},\quad 0 \leq t \leq 1, $$ with $p_{1} = (0, 1)$, $p_{2} = (\frac{8}{3}, 1)$, $p_{3} = (\frac{4}{3}, 0)$, $p_{4} = (4, 0)$.
Dmitry Baranovskiy's Raphaël JavaScript library has an interactive demo for drawing splines.