I think your question has a deep connection with Riemann Normal Coordinates.
The basic idea behind Riemann normal coordinates is to use the geodesics through a given point to define the coordinates for nearby points. Let the given point be $O$ and consider some nearby point $P$. If $P$ is close enough to $O$ then there exists a unique geodesic joining
$O$ to $P$. Let $a^\mu$ be the components of the unit tangent vector to this geodesic at $O$ and let $s$ be the geodesic arc length measured from $O$ to $P$. Then the Riemann normal coordinates of $P$ are defined to be $x^\mu = sa^\mu$.
One trivial consequence of this definition is that all geodesics through O are of the form $x^\mu(s) = sa^\mu$ and that the $a^\mu$ are constant along each geodesic. By direct substitution into the geodesic equation
$$\frac{d^2x^\mu}{ds^2} + \Gamma^\mu_{\alpha \beta}\frac{dx^\alpha}{ds} \frac{dx^\beta}{ds}=0$$
and its derivatives, one obtains, at the origin $O$
$$\Gamma^\mu_{\alpha \beta} = 0$$
$$\partial_\nu \Gamma^\mu_{\alpha \beta} + \partial_\alpha \Gamma^\mu_{\nu \beta} + \partial_\beta \Gamma^\mu_{\alpha \nu} = 0$$
From this results it is easy to see that
$$\partial_\nu \Gamma^\mu_{\alpha \beta} = -\frac{1}{3}(R^\mu_{\alpha \beta \nu} + R^\nu_{\beta \alpha \nu})$$
from which it follows that
$$\partial_\alpha \partial_\beta g_{\mu \nu} = -\frac{1}{3}(R_{\mu \alpha \nu \beta} + R_{\mu \beta \nu \alpha})$$
and finally
$$R_{\mu \nu \alpha \beta} = \partial_\mu \partial_\beta g_{\alpha \nu} - \partial_\nu \partial_\beta g_{\alpha \mu}$$
This result can finally be used to reexpress the Taylor expansion of the metric in terms of the curvature i.e. The Riemann tensor. The Taylor expansion reads as follows
$$g_{\mu \nu}(x)= \eta_{\mu \nu} + \partial_\alpha \partial_\beta g_{\mu \nu} \frac{x^\alpha x^\beta}{2} + O(\epsilon^2)$$
Therefore
$$\boxed{g_{\mu \nu}(x)=\eta_{\mu \nu} - \frac{1}{3}R_{\mu \alpha \nu \beta} x^\alpha x^\beta}$$
Thus the leading terms of the metric could be expressed as a sum of a constant part plus a curvature part for nearby points. See that this result is not valid for points that are further away, where the Taylor expansion of the metric is not applicable and the unit tangent vector is not constant along the geodesic joining $O$ to $P$.
Physically, the real gravitational field is not the acceleration but the tidal forces that can not be vanished with any coordinate change. Tidal forces are usually measured as a geodesic deviation breaking the locality of two observers far enough apart.
As an example of this coordinates we have the Schwarzschild black hole, where near the event horizon can be shown that the metric of two nearby points has the same form than Rindler coordinates of an accelerated observer in a flat spacetime.
More information in Riemann coordinates.