Well, if you read my "Social Implications of Magic" articles in The Guild Companion, a fair amount of the content is based on thinking "What would I do with these abilities if I were a normal person with a job instead a wandering kook?" Since the spell lists were built with adventurers in mind, I'd say a fair amount of the results include unintended uses.