We stayed for one night during our stay in SF.
I can imagine that the neighborhood might seem a little sketchy for some people but we had no problem and everything worked out fine.
Would recommend for a one night stay.