Depends entirely on what game you are playing.

In Champions, intelligence is most certainly a super power.

In AD&D you couldn't cast spells unless you had a high enough Int for that spell level, meaning that intelligence literally gated your ability to use magic. An intelligence of 19-20 was rated as "supra genius" and higher than 20 was "godlike".