The Marina is always good. Most of Fisherman's Wharf area. For AirBnb, I'd focus on anything close to the muni metro trains (this could mean outer/inner Sunset. Using the metro is an easy (and inexpensive) way to get around to nearly all attractions. Parking near any of the major attractions is hideously expensive. We had a girl's weekend in San Francisco last year, and rented a very nice flat just 1/2 block from one of the metro lines. Easy to find parking in the neighborhood, and it was a very "local" experience, with nice neighborhood restaurants and bakeries within easy walking distance. The Financial District was 20 minutes away. We strictly used the Metro and Uber ($6-7 to/from most attractions). I'd be happy to share the place we rented, or let you know about the neighborhood for any others you are considering. I lived and worked in SF for 20 years and know it well.
Another option might be to stay just outside the City, and use the local public transport options to get you in and around the City. Generally, if you look just outside, you'll find less expensive/larger properties. Southern Marin is nice because it is connected via ferry boat to the City. The ferry ride to and from is an attraction in itself.
I love SF, and still own a home in the area to which DH and I plan to retire in a few years. The climate is magnificent.