I guess most summon spells that deal with outer planes could easily have had non combat content which was absent. Then there are all the spells like Friends, Wish, True Sight, Infravision, Spook, Horror, Emotion, Know alignment, Farsight in BGs which could have easily had a story based role. NWN2 has way more spells than that which are non combat utility. The real problem is that they are useless as MOST if not all the "spell using"encounters are combat based.
Friends was of extremely limited use in the IE games. Wish was never properly implemented (couldn't be, since there's no way to implement such a thing in a computer game). True Sight was primarily a combat buff. Infravision was there and I think I even cast it, once, before acquiring an object that had it on it when I needed it. Spook, Horror, Emotion were all combat spells (and good ones at that). I'll give you Know alignment but... when was that actually useful? Farsight... no recollection of using that.
PnP is a whole 'nuther ball game--dig or passwall, anyone?--but I honestly don't recall having much use for magic out of combat in any of the IE games or their successors. Crafting, of course, but that mostly used combat spells.