Ever see the TV Show, Bones? The forensic investigator (Bones) is a perfect example.
She just Doesn't Get human interaction in any way, and keeps assuming it is or should be logical. Which, of course, it isn't.
She's a sympathetic, nice, attractive woman. But she has classic lack of social skills.
Add in a bit more myopia and tunnel vision with problems, and you could capture the lack of Wisdom; take things fairly literally.
Actually, thinking about it, high Int, low Wis/Cha fits asperger's and autism, I think.
Oh, and as for Cliff Claven, one thing that's always ticked me off about Cheers... at the beginning of that series, Cliff was RIGHT all the time. He was the infinite source of random, correct, facts. Which was funny. It was only later that he turned into a complete sad sack, which I found a lot less interesting (since it had an edge of cruelty).