My husband and I love it so much we held our wedding there. It is a magical setting for a wedding. Our wedding was a Renaissance Theme, several dozen people in period clothing. It was a sight to behold. We had a woman come up to us and tell us that she sees weddings there almost every week (she lives across the street) and ours was the most beautiful and original she has seen in all the years she lived there.
The acoustics are very interesting. If you stand in the exact center of the rotunda, and clap your hands one time (loud) the sound echoes several times quite distinctly.
There are lovely swans, too. Swimming elegantly along. Creating a dreamlike atmosophere. Esp on foggy days (not many of those in SF, right?)
The only show I have seen there was my wedding, but it was a great one.