My cousin went there and loved it. It's a WCC catholic school (jesuit order) but honestly, there's nothing about it that really screams that. Sure, there are some classes and curriculum that are driven in that direction, but it, as well as Saint Marys in the East Bay (and other west coast catholic institutions) are very much progressive as hell when it comes to schools with a religious affiliation (I mean, it's the Bay Area, you don't get much more progressive than that)
It's in a quieter part of the city, and is sorta detached from the downtown flavor, but that can be a good thing as it's not going to be insanely distracting as Downtown schools like NYU might be. That said, you can get on the bus and get anywhere in the city really quickly.
The education is top notch, and they do have a good penchant for offering adequate scholarships. I'd definitely consider it if I were you regardless of the very rad location.
..something to note though, if your'e not getting a lot of funding beyond general tuition, it's going to be difficult to afford, if anything because San Francisco is the most expensive city to live in within this entire country (yes, more expensive than New York and LA)
Finding a non-ghetto ass room for rent under 1200$ is not an easy task in SF - especially if you're picky about where you're going to live.
...not sure what your program is that you're going into, but if you're considering USF, also check out Saint Marys in Moraga - it's slightly cheaper cost of living, has a more lively campus, is also in a cool spot (10 or so mins from Berkeley) and I'm pretty sure it has just about the same programs for the most part.
Perhaps also check out University of Portland and Seattle University. Gonzaga as well (if you want to be closer to skiing) Any of those would be really sweet schools to attend and are in pretty cool spots.
Have a nice day, Bluename.