It's worth the trip if you've never been to the Bay Area. As someone who has lived here for 6 years now, the hype of San Francisco is more about how the city was rather than what it is now. If you're able to ignore rampant homelessness and open use of illicit drugs like crack and heroin on the streets downtown, SF still has all of the normal bourgie delights such as high-end shopping, restaurants with decadent food, etc. Personally, having seen firsthand how bad the homeless/drug use situation has become in just a few years (from normal big city amount to fiscal crisis levels in just 4 years), I only go downtown SF for specific, time-bound reasons. Like meeting with a provider 
The suggestion of Union Square is a good one. The suggestion to explore other areas such as the southbay (San Jose, Santa Clara, etc) or even Marin (Sausalito, Belvedere) is even better. Depends on your clientele. If you're looking to hit up locals, try going north or south. If you're hitting up clients who aren't local residents, Union Square is probably your best bet to stay.
Yes this board is quiet. We're trying to make it more lively. There is another board that popped up after a very popular SF board was shut down. A lot, but not all, traffic is over there.
As far as best spots when touring, I'd say that most visiting escorts stay in the SF Union Square area. There are a lot of hotels, as well as shopping, restaurants, theaters are close by Lots of foot traffic, local and tourist in this area. The SF financial district is also nearby. You may get some clients who ask about public transportation such as BART, Union Square and financial district are very close to BART.
There are large hotel chains as well as smaller boutique hotels. You might want to stay away from the smaller boutique hotels, as they might require key card access to get to the rooms.
The southbay is also a good area, but I am not as familiar with it. I did visit someone who was staying at a downtown San Jose hotel. Also I seem to recall seeing ads for escorts staying near the San Jose airport. Also the Sunnyvale, Mountain View, Santa Clara areas are also popular, this is where some of the larger tech companies are located or very close by. I know that many escorts stay in Santa Clara, there are several hotels close to Levi's Stadium where the 49ers play.
Some escorts also stay at the hotels near San Francisco airport, but there isn't that much to do during downtimes and I don't know how much business they get as it is a drive from the hubs of SF and San Jose.
-- Modified on 3/15/2018 4:51:01 AM
I live in SF part-time and have only ever worked downtown/in the financial district. It's pretty dead there on the weekends and stuff but it's not too bad for work as it's easy to reach for almost everyone. I've never had anyone complain about my locations, but I do get a lot of calls to Oakland and I hear more and more providers are moving their main ventures over there. I hope you do visit. Like the above response, there's a ton of homelessness but the grandeur of the city still shines through
