It makes intuitive sense for San Francisco to be "the most profitable rent in the country" as you claimed, but the surprising and counterintuitive truth is that it's the opposite.
They've made more money from appreciation than from rising rents.
Appreciation, by itself, will naturally drive this ratio down because of rent control laws. The value of the home is the denominator in that fraction.