Visiting SF

Going to SF for a weekend to see the 9ners vs Tampa Bay. Staying near SF Airport and decided to get a rental vehicle. Read different opinions regarding driving in SF. Any thoughts?

Also any recommendations of places to eat and visit?