Don't let how he looks scare you off, this guy is a crazy talented guitarist.
John 5, formerly with Marilyn Manson and currently with Rob Zombie, is an artist of varying talents. From Bluegrass style finger picking to metal shredding this guy is reasonable able to cover the bases.
I watched an interview once where he said all he really wanted to do was have a sound that people would hear and think, "Oh, that's John 5" in the same way that people would say "Oh, that's Vai" or "That's Satriani". Listening to his material I would say that he achieved that.