I would say where you would like to live depends on where you are moving from :-D

I like Twin Peaks myself (although it's pricey). If you are moving out from a suburb and would like to "ease" yourself into the city, Twin Peaks would suit you just fine. One of the additional perks is that Twin Peaks is right in the middle of SF.

I lived in Hunters Point for a while (super cheap), and taxi drivers would refuse to take me home (due to the high crime rate in that area).