You have a lot of hills to choose from in San Francisco but in my opinion the best (and most varied) views are from Bernal Hill. Bonus: from my kitchen table I can watch tiny blobs moving around on this hill-- slow blobs are people, fast blobs are dogs.
Located near to the Alamo square's Painted Ladies is this wonderful gothic "stick" Italian villa with a long weirde history. Built by a Candy Baron in 1889, it's housed variously; a Russian Czarist nightclub, Jazz musicians, Satanists, a Manson family member, and one of the first 60's Hippy communes -Calliope. Creepy as hell enshrouded in fog after dark.