Don't let the video scare you. The road is awesome and a lot of fun to ride. As many have stated previously; ride this in the middle of the week if possible, less of the crotch rockets and sports cars trying to see how fast the can make it thru.
Rode the Dragon with my wife this past October; 2 up on the old Road King. She was a nervous about riding it due to the fact that she is not real fond of twisties to begin with, and the stories she has read/seen/heard on the internet and thru friends. Once we got down to the store and stopped for a rest, she said she enjoyed the ride and decided that it was not as bad as people made it out to be. She even stated that she would like to ride it again some day.
The key to any riding is to ride within you own limits, don't let the other riders around you force you out of your comfort zone.