I knew a guy like that when I worked for Poland Spring water in their warehouse in Greenpoint Brooklyn New York 25 years ago. He had insane retention, I mean to the point where you’d ask him about anything and he would go into detailed explanations about it, and he could even tell you what happened on a certain time and date, but he was what I suspected borderline autistic and had trouble following orders and getting tasks done. It was sad because he use to have an elderly mom he lived with who would pick him up and he had to be in his 50s back then, he couldn’t even drive. His mom would drive him to the warehouse and he would wrap pallets with shrink wrap and sweep up and that’s about it but he was like a walking computer. Utterly brilliant but that essential ingredient was missing that would have made him independent and a success in society.
I recall reading decades ago that many of the highest IQ people work in repetitive, isolated jobs. The thinking was part of what you said (social aspect) and the repetition allowing them to free their minds to work on numerous other ideas. So it seems repetitive work is not a real problem (frees your mind) but having to live at home with your family (no independence) is the real kicker. A genius inventor uncle of mine was able to live alone but kept dropping his paycheck on the floor -they found them all over the building - until they had direct deposit opened for him. The mind is busy elsewhere.
Usually incredible geniuses in certain areas are lacking other types of intelligences. Doesnt help them when they cannot relate to other people, get simple tasks done, cannot physically do normal things, of get addicted to drugs. One relative of mine has a great theoretical mind but has terrible personal skills and has had serious drug problems.