Shyan said:
I mean, what they say at early stages, implies that acceleration should be able to curve space-time and that's very confusing. In fact, for me, its the single wall stopping me from understanding GR completely.
You are not the first person to be confused here and I blame the textbook authors
Here's one way of working through the maze:
1) Acceleration means you are not following the path that inertia says you ought to be following.
2) Classical physics says that #1 is always due to net force that is pushing you off that inertial path.
3) Classically, when you are standing on the surface of the Earth you are not accelerating because two forces (gravity pulling you down, Earth pushing you up) are exactly canceling so there is no net force. This is consistent with #1 and #2.
4) Classically, when you are standing on the floor of an accelerating spaceship you are accelerating (along with the floor) because the floor is pushing you and there's a net force because there's no counteracting force. This is also consistent with #1 and #2.
5) Einstein's insight: #3 and #4 are (locally) indistinguishable. Therefore, it should be possible to describe the #3 situation as if it were a #4 situation.
6) So we try describing #3 as if there is only one force at work, the Earth pushing on you.
It turns out #6 works remarkably well - we just need an explanation for why the natural inertial path in #1 seems to want to intersect the ground. And that's easy to see if you just imagine that the ground wasn't there but the gravitational field still is (imagine that the Earth suddenly shrinks to a point leaving you floating above its surface - ##F=Gm_1m_2/r^2## still works and you're still at the same distance ##r## from the center of the earth). No Earth pushing on you, so you're in free fall and experiencing no acceleration as you fall into an elliptical orbit around the center of the earth. When we say that objects "fall" towards the earth, we're actually saying that their inertial no-force-acting-on-them trajectory intersects the surface of the earth, which then applies forces that accelerate them off that inertial trajectory.
Curvature is the reason why the inertial trajectory takes on the shape that it does. Mass creates that curvature, but acceleration does not. Instead, acceleration happens when forces act on you to push you off your inertial trajectories; firing a rocket engine is one way of creating such a force, and objects like the surface of the Earth pushing on you because they're in the way of your curvature-determined inertial trajectory is another.