Thing is that is more like the stereotype nerd/geek thing... I guess maybe video game addiction might kill this off a bit in time but I'd suspect that historically some people have done better than normal in some narrow field they were drawn to because they were social outcasts and simply spent a lot more time focused on that area.
I guess this whole question is rather subjective but I don't think I could really consider someone "smart" if they lack the ability to carry out basic tasks (actually physical disabilities aside).
Some of the "smartest" (IMHO) people I know or have met are pretty well rounded, one quant I know speaks several languages, is very gifted mathematically and is also pretty talented as an artist. I don't think anyone who met her would assume she is a nerd/geek either, she's pretty sociable too.
There is a ranking