I lived at the corner of Turk & Divisadero
Which was a very nice area to live in, even though I hear it's drastically changed since two years ago (which is predictable, but still worrisome). My workplace however was at Folsom & 8th, which only came alive at night, and during the day was as faceless and deserted as anything. Judging from Chester Hartman's "City For Sale", the whole history of SoMa's "renovation" was extremely shady, shitty and damaging. Even though it may not have been the safest of places back in the day, it at least gave that part of the city some personality, which has been completely wiped out. There were still some really interesting places to go. DNA Lounge is probably the closet the city had to European nightlife as is common in Berlin or Barcelona or etc., but with a nice twist. I'm pretty sure that's extremely not your thing at all, but I liked it, albeit for insanely overpriced drinks. But overall SoMa in my experience was so depressing I don't even want to think about it.
I generally definitely pity the SF's natives like you the most. From what I read and know, the whole relationship between SV giants, the tech money and the city government eventually screwed you up the most of all and left you completely out of control of the changes that came not only a couple of years ago and not only in the 00's, but already in the 80's.