I have always wanted to live in san fran'...?

is it really great living there as it seems? i heard its realy expensive...how do i choose an affordable apartment while still being in the city?