I love the SF Hotel des Arts. They are right outside the gates to Chinatown, I think, a short walk from the Financial District, and they are a hip little hotel. They got a bunch of local artists to paint entire rooms, which are bad-ass. Check it out:
You have to reserve the painted rooms specifically, of course, since they are all entirely different. And be careful, some rooms don't have full baths, it's kind of European-style. Some do, though, so just pay attention to which you book.
Oh, wait, it says all the painted rooms are queen bed, full private bath. $100/night. For SF that's pretty cheap, especially since they're awesome.