"Rotor" is the ride you're referring to and is no longer in the park. It was a right of passage as a teen in the 70s to ride that, get off, and hurl.
Busch Gardens Williamsburg is my 2nd favorite theme park (and I've been to a LOT) only trailing Disney's Animal Kingdom Park. Both parks are very happy places for me to immerse myself in.