I think it would be a great museum for undeveloped land in Tacoma or Oakland, though.
We aren't talking about any old plot of land here. This is land that is held in trust for the public. It certainly didn't help that the proposed design for the museum was steeped in the kind of faux nostalgia one would expect of Lucas. The first time I saw the design I thought I was looking at a new Westfield mall development in San Jose.
In HS I ran cross country and we would sometimes meet up at that location for our Presidio runs. You can count me among those that would rather have a discount sports store at that location rather than a permanent monument to an out of touch billionaire's ego.
Again, I'm also very much against much of the building review process I see on display in SF, especially as it relates to things like architectural review. Even historic preservation, while well meaning, is often misused in SF to block development. Part of the reason that SF is so expensive to build in is a result of the permitting process where neighbors can lodge complaints to hold up development even in cases were the proposed building falls completely within the normal zoning guidelines. With very few exceptions I completely disagree with architectural/design based aesthetic building reviews and generally view most zoning rules as a way to exclude poor people from certain neighborhoods, or increasingly, entire cities.
However, in the case of a museum being situated on exceedingly rare open public space, I can make an exception to my dislike of architectural review. This is public land being gifted here, I think the citizens of the city have a right to have their opinion heard on whether or not the proposed building's design conforms to their desire for the site. SF has no shortage of good examples of crazy NIMBYs but I still don't feel like this is a good example of NIMBYism when the development is situated on public lands that are specifically held in trust for the community.
Just because it's accessible doesn't make it inferior. Pre-Raphaelite art is also pretty heavy on the eye candy and nobody complains about that. Conversely it's not like you can't find any cheese in the De Young or other local museums - indeed my favorite painting there is rather conventional, an important factor in the heist I'm planning.