I'm not sure how shamans/priests pay for learning spells. On the one hand, I imagine that magic follows some sort of economy such that it is not available for free. (A shaman might be willing to dispense healing for free, but she has to pay for her magic somehow.)
So I'm thinking, not only is the question what a person would like to have, but what would a person be willing to pay for? A "Silvertongue" spell would be nice to have for a mayor, but unless there is a lot of cuthroat competition, some simple voice training would probably be more effective, and that magic be used to protect himself from sharp objects, or even to make his wife look stunningly gorgeous.
In cities, there would probably be a "magic arms" race between the authorities who use magic to put a lid on crime, and the criminals who use magic to commit crimes. My thinking is that the gods would in general take a dim view of being exploited by mortals, and so the gods of justice would provide plenty of anti-magic charms, while the gods of thievery would be a little stingy about sneaking-around charms. (You want Chameleon? You have to cough up some good cash first....)
Another question is that while everybody would love to have powerful spells, very very very few people can actually get them. To reference my homebrew D&D campaign of Audor: yes, there are a lot of 4th and 5th level spells that are very useful in combat, but the army that the PCs marched with didn't have any wizards above the 4th level, so they were limited to using 1st and 2nd level spells. The same principle probably applies in Runequest: lots of 1 point spells, but few 3 point spells.
When I get home, I'll think of a few spell ideas. In the meantime, I suggest The Book of Erotic Fantasy as an interesting reference for spell ideas that might be found in some areas. If I can get my mind out of the gutter, I'll probably think of more.