Even worse in places like SF or also frequently becomes the turn lane for cars at the end of the block resulting in everyone being upset.

Are they better than nothing, which is what was there before?

Marginally. They do help some cyclists, and they reserve space for future, better bike lanes. On the other hand, they're inefficient because most people rightfully determine they're unsafe and won't use them, which gives ammo to anti-bike crusaders.