It doesn't rotate,but is an amazing place for cocktails.
The Top of The Mark does not rotate but has the best views of the city to see the Golden Gate Bridge. Cityscape Lounge offers great views of downtown if you're more into the new SF skyline. There was one called Equinox, which sat atop the Embarcadero Hyatt. Used to go there for dessert and got the Strawberry Godiva Dream. SF does have a few rooftop restaurant and lounges in the works but nothing rotating (yet). Hope this helps.
Thank you Vincent! I will check out the places you described.
Thanks! Your answer is awaiting moderation.