Have NOT stayed there but the Westin St. francis is centrally located, nice rooms, nice facilities... a bit on the expensive side.
The Hilton HOtel/Towers is generally where I end up being put up... gigantic and average rooms unless you get upgraded to a mini suite but again, good location.
There's also the Fairmont which I think is San Fran's oldest hotel.
There's also this little hotel off Powell street whose name I can't recall. It's near this breakfast place "Sears" (not affiliated with the department store chain) with great pancakes and waffles. I can't recall the street either.
Nice homey little hotel. Some business people stay there. I think rates between 75-85 dollars. Fodors gave it a good writeup.