We had a good tornado (F4) in Huntsville, AL, back in 1989. A guy I worked with said he was driving along and the vehicle in front of him lifted straight up in the air and was gone. There were also entire apartment buildings blown sideways off of their foundations.
The creepiest thing I ever saw though was when an F5 tornado went through just north of us. The local news film crew was showing some footage of where the tornado went through and I was thinking, "that's not tornado damage, that's a dirt road through the woods!". Come to find out it
was tornado damage. The tornado removed the trees and even removed the
grass from the ground. Even people in basements were killed in that tornado.
Another tornado went through just north of us and hit a really nice subdivision and destroyed alot of houses. It was even named after the subdivision. It was called the "Anderson Hills" tornado. It went about a mile north of my house:
http://en.wikipedia.org/wiki/Anderson_Hills_Tornado