The Red Victorian was pretty much everything we hoped for. Great location, close to public transit, and lots of funky character. Check in was easy and there are tons of great local restaurants (and Golden Gate Park) just steps away. Everyone we met there was kind and helpful. There is a local grocery store, Whole Foods, and several liquor / convenience stores within a few blocks. The neighborhood is brimming with independent bookstores, game shops, comic book stores, and vintage clothing boutiques.
I think it's worth mentioning that you will definitely encounter people who are living on the street as you are out and about in the neighborhood -- it is just part of life in San Francisco. We always felt safe at the Red Victorian but it might be a bit of a culture shock for travelers who have never seen that IRL before. Our room (the Rose Garden) was on the third floor, so I would not suggest it for people who tire easily or have mobility issues -- the stairs are winding and you need to watch your footing as you go up and down.
My husband and I had a late flight back to the east coast in the evening after we checked out, so it was wonderful to be able to hang out in the common space downstairs until we had to leave for the airport. Overall we had a great experience and would definitely recommend the Red Victorian to our friends visiting the neighborhood.