I have Yngwie's video, that first one, and I watch it and it's really cool and he's a funny dude too, and for about ten minutes afterward i feel the need to play as fast as him. Then, i do, then i feel better.
As for putting his sort of technique to good use, that's difficult. (You should see how terrible the Blues section of his video is). He inspires me to keep up my chops, definitely, but that's about it.
Atomic