One of the most reliably slow and entertaining ways to get around the city!
The F Market line (officially "Historic Streetcar Service") is a collection of vintage streetcars that run from the Castro down to the Ferry Building and then follow the Embarcadero to Fisherman's Wharf. The truly inspired can track the various cars in real-time!
The F Market Streetcar is different than the Cable Car lines - there is no waiting and it costs a fraction of the price :)
Wikipedia: http://en.wikipedia.org/wiki/F_Market_%26_Wharves