Just got back from a business trip to San Francisco and skated at Yuerba Buena. Unless you are a frequent skater and have one of the membership cards, you need to call ahead and reserve a freestyle session (by the half hour: I believe it is $7.50 per 30 minutes). Music is uploaded onto their online software and you need a special key card to play it on the overhead system. Reservations can be made 2 weeks in advance, and they only allow 24 skaters per session.
Ice is soft and the building is on the warm side. There are huge Windows that let you look into the adjacent park. It is a beautiful rink and adult-friendly.
Brian Boitano apparently skates there but doesn't show up until around 9:30am on weekdays. I skated the 6am freestyle sessions so did not see him.