I have found the upper half-space coordinates on hyperbolic space $\mathbb H^d$ highly technically convenient. In these coordinates the metric takes the form $$g = f(x)((dx^1)^2 + \cdots + (dx^{d - 1})^2 + dy^2).$$ So the metric is a rescaling of euclidean metric written in Cartesian coordinates (if we take $f(x) = (x^1)^{-2}$), and have the added bonus that $\partial_y$ is a Killing field. For the project I've been working on recently, neither of these facts are terribly useful by themselves, but together they are highly powerful.
But I do not understand the mechanism by which such coordinates arise. Right now it just seems like some weird miracle that happens in constant nonpositive curvature. The obvious necessary conditions are that the Cotton ($d = 3$) or Weyl ($d \geq 4$) tensor vanishes, and that the local isometry group of $g$ is nontrivial (so you can pick a local Killing field). But I would be surprised if these conditions are sufficient.
What are necessary and sufficient conditions to write the metric in the form $$g = f(x)((dx^1)^2 + \cdots + (dx^{d - 1})^2 + dy^2)?$$
Here are some preliminary thoughts. I think that you can get a similar metric on $\mathbb S^2$ by writing out the scalar curvature for a metric $e^{2\varphi}(dx^2 + dy^2)$ where $\partial_y \varphi = 0$: $$R = -2e^{-2\varphi} \partial_x^2 \varphi$$ which is an ODE for $\varphi$ that can be solved using local wellposedness for ODE. Actually, feeding the ODE into a computer algebra system for $R = 2$, I think you can take $$e^{2\varphi} = 1 - \tanh^2 x.$$
This method clearly doesn't work for $\mathbb S^3$ since it's not enough to impose constant scalar curvature, you also have to impose that the traceless Ricci tensor vanishes. So you get a somewhat overdetermined-looking system of PDE. For $\mathbb S^d$, $d \geq 4$, you must also impose that the Weyl tensor vanishes...
By the way, I know that sometimes these questions about "when can I write the metric in such and such form" can be deceptively easy. If this question is more suited to MathOverflow, please let me know.