It costs more to live in San Francisco that it does to live in Detroit. However, that additional cost is largely static: You'll pay a lot more for housing, you'll probably pay noticeably more for food, and you may pay somewhat more for clothing and other items. You won't pay more for a car (if you have one), you won't pay more for the items you buy from Amazon, and you won't pay more for your Netflix subscription.
If you earn $30,000/year, the difference in cost of living between San Francisco and Detroit will be dramatic. You may not be able to afford a place to live in San Francisco at all on that salary.
If you earn $300,000/year, the difference will be almost negligible, since your living expenses will be a trivial portion of your income. (The one kicker will be housing--you'll probably need to settle for a smaller living space.)
It doesn't make any sense to apply a cost of living adjustment as a strict multiplier, which that calculator does. It claims that someone making $30,000 in Detroit will need an $80,000 salary in San Francisco to be equivalent, while someone making $300,000 will need $800,000.
That's clearly ludicrous. It does not cost an additional $500,000 annually to live in San Francisco.
Determining equivalent cost of living is a complex question, and will always be imprecise. There are things that simply can't be converted--on my current salary, I could afford to buy a house with a hundred acres of surrounding woodland near my home town. There is no amount of money in the world that will buy that in San Francisco. Equally, there are many things available in San Francisco and its environs that can't be had for love or money in my home town.