OK, it's tacky and touristy, but it's fab. Hang on to the side while you race down toward the Bay, or better still, late at night shooting down California Street. Better than a fairground ride.
There are cable car turnarounds at the bottom of California Street and at the bottom of Powell Street;
www.sfcablecar.com