TLDR: yes, you should stay here. Read more if you want to, but this is a recommendation.
The neighbourhood is amazing, to start. Clean, diverse, with great restaurants and a grocery store right down the road.
The place itself is small but clean. Little touches, like the binder of suggestions for places to visit and the best (the BEST) pillows I have ever slept on were so appreciated. Honestly, I don't think I could keep a place looking that nice in a climate that humid. And that's where the downsides came.
It never dried out in there. We had the fan on in the bathroom for hours and our towels never dried. There were also little things like no spare towels and an ironing board but no iron. When we asked for spares, they were supplied in good time, but with no additional communication from the host. That's really where the star was lost.
There are very strict rules for staying in the place, with monetary charges if they weren't followed (don't leave any stains on any of the linen and must turn the bathroom fan on or the fire department will show up.) Between that and the complete lack of communication from the host, there was a feeling like they set everything up lovely, but really discouraged hearing from us after that.
This went both ways though, in that we didn't hear anything from them. We were warned that there was a family in the house above us, but we barely heard a footstep. Very pleasant neighbours.
In summary: visit SF, stay here, ask for more towels early.