And yes, it's a detectable signal. "in a large population-based cohort it was found that up to 4% of brain cancers were caused by CT scan radiation" --somewhere on Wikipedia
CT scans vary in dosage. Wiki gives ~10 Sv for an abdominal CT; I don't know where Scott got 30, but maybe the kidney screening is multiple scans or otherwise higher dose. Or he was wrong by a factor of 3, which is not a factor of 100.
CT scans aren't done frivolously, and the current rate of scans is hotly debated for exactly this reason. I'm a little surprised that kidney donation involves CT over MRI by default, but I'm not an expert.