As parents with kids likely already know, Legoland California Resort has a section of the theme park called Miniland USA which can be cruised through on a boat or toured on foot. Miniature Lego versions of New York City, Washington, DC, New Orleans, and Southern California are all included (per the site, at Halloween, "the New Orleans cemetery 'comes alive' with dozens of zombies and skeletons crawling out of the graves."). But they also devote a section to San Francisco, with a Lego-built Golden Gate Bridge, Coit Tower, Lombard Street, the TransAmerican Pyramid, the Painted Ladies, Chinatown, Pier 39, and more. There's even a working Vaillancourt Fountain (which wasn't working in real life until last week, and is now temporarily on with some blue chemical running through it like a chemical toilet).
Of course the city depicted is a condensed, Vegas version, geographically (and as you can see in photos taken here from a cruise boat by Gothamist co-founder Jake Dobkin, the New York City skyline can be seen right behind it). They haven't yet added Salesforce Tower or or any of the other new additions to the skyline, but that project is perhaps in the pipeline.
Geographically sort of correct is the California Street cable car headed to Nob Hill, though it looks like Nob Hill is missing, and 555 California is totally in the wrong place. Also, they put the Hyde Street cable car turnaround in the right place, between Fisherman's Wharf and Ghirardelli Square and they've used real sounds recorded at Pier 39, including barking sea lions, to accompany the display.
Below, you can see some YouTube video shot of the SF display, which has been part of Legoland California Resort opened in 1999 in Carlsbad the first such park to open outside of Europe. All the SF buildings were constructed in Billund, Denmark and brought here for the park.
In 2010, the resort added a water park, and in 2013, they added a hotel that features themed rooms for kids.