Average Holiday Inn
We stayed here in the Summer as we'd heard it had the best views of fishermans wharf. We definitely weren't disappointed with the views, they were fantastic - we could see Alcatraz and the 4th July fireworks from our room! 
The hotel itself was in need of a refurb, things were very tired, and the breakfast wasn't great. It had free wi-fi in the lobby though!
An ideal base if you're stopping by San Fran for a few nights with kids, it's in the perfect location.