I’m not sure the causality is that clear—typical fiction pulls from cultural norms at least as much as it pushes them. I fully agree with your underlying belief that common thinking about intelligence is massively oversimplified. Note that this applies to HUMAN intelligence as well.
Typical fiction has probably framed thinking about the development of intelligence in non-humans in bad ways.
C3PO from Star Wars seems like a nervous language nerd.
Data from Star Trek mostly seems like a human with a built-in calculator.
The Planet of the Apes suggests that getting intelligence means getting a draw from a human-population IQ distribution.
All other artificial intelligences can be outsmarted. Otherwise the movie would not work.
Data, C3PO etc never have wifi.
I’m not sure the causality is that clear—typical fiction pulls from cultural norms at least as much as it pushes them. I fully agree with your underlying belief that common thinking about intelligence is massively oversimplified. Note that this applies to HUMAN intelligence as well.