I have found that I'm a visual person and although tab has helped me greatly, DVD instructional video's are the best for me to learn. That's why I love the video on this site! The reason I like dvd's is because when you pause it's clear, I can set the speed for 1/16, 1/4, 1/2, etc. and really learn at my own pace and see more than the tab can show me. I have amassed some great ones and seen some that aren't and wanted to share some of the better ones (imho).
First off, the Legendary Licks one of the Dead is one of my top picks. It's been discussed here already, so I'll just say pick it up!
Jimi Hendrix - Learn the songs from Are You Experienced is another great one. Andy Alendort is the premier Hendrix guitarist/historian and he shows you all the songs, all the parts and even includes some clips of Hendrix playing.
The Signature Licks series is pretty good. I have the Allman brothers and really have learned a lot. I also have the Lynyrd Skynryd, which is just plain fun to play, The Beatles and Eric Clapton's Early Years. They only pick a few songs and show too much of the person playing, but they are professionally done and follow the tab in the books very close. The Clapton is great because they include a jam section that let's you play along with what you've just learned.
Lastly, one of the best is available on ebay at this site:
AJ-Multimedia on ebay
I have 4 of them from this guy and I use them often to learn. They are NOT professional, but the guy dispenses with showing his face, and rather just shows the fretboard. He also plays the actual song and then plays along with it, stops the cd and shows you the parts. He breaks them down slowly and usually they are easy to play. Often he tells which scale to use or which key something is in and throws in something extra. They don't always correspond to the tab that is out there, but they sound right on when he's playing along with the cd's. He's kind of got an obnoxious voice, but his slection of classic rock is great, his song selection is right on, his prices are reasonable and the ordering process is simple.
So, those are my recommendations. The major one that I don't like is the "In the Style of.." since they only include small snippets and riffs and don't have any complete songs, only play the riff twice and don't tell you much about it.
If anyone else has found any that are good/bad, I'd love to know about them.
"The only funeral you should ever try to interrupt is your own, and that should be a full-time job." -Kinky Friedman