"The Sundial" on top of the Westin in downtown Atlanta has a revolving rooftop restaurant. Generally, these restaurants turn very slowly, like 1 full revolution in 30 minutes, which is not quick enough to evoke motion sickness, at least not compared to how much the 70 story, slender tower sways on a windy day.
http://www.sundialrestaurant.com