Is there a 3D coordinate transform which turns rotation in cartesian coordinates into translation in the transformed coordinate system? It would be sufficient if the transformation has the desired property only for small rotation angles.
In 2D, the polar transform turns a rotation of $(x,y)$ by the angle $\alpha$ into a translation in polar coordinates $(r,\varphi+\alpha)$. In spherical coordinates, the desired property only holds for rotations about the z-axis and not for more complex rotations, e.g., about the z- and y-axis.
Under a different question a user hinted in the comments that "stereographic coordinates" work. However, I do not see why (and I cannot ask there because I lack reputation).